User Account

All Pages

Calculate the total present value of the given cash flow

Assignment Help Accounting Basics
Reference no: EM132246692

Question: Submit your spreadsheet with your template and results for the following questions. Your worksheet should be named "FINC 3733 Excel Project 1_Your Name". Please do not submit before you finish all six questions.

1. Calculate the FV of $500 in 5 years, with 5% interest rate

What if the interest rate is 6%, 7%, 8%......

What if the N changes to 6, 7, 8......

2. Calculate the PV of $500 in 5 years, with 5% interest rate

What if the interest rate is 6%, 7%, 8%......

What if the N changes to 6, 7, 8......

3. Calculate the FV of a 5-year annuity of $500, with 5% interest rate

What if the interest rate is 6%, 7%, 8%......

What if the N changes to 6, 7, 8......

4. Calculate the PV of a 5-year annuity of $500, with 5% interest rate

What if the interest rate is 6%, 7%, 8%......

What if the N changes to 6, 7, 8......

5. Calculate the total present value of the following cash flows when the interest rate is 10% per year:

$100 at the end of year 1

$300 at the end of year 2

300 at the end of year 3

-50 at the end of year 4

6. Construct the amortization table for the 4-year car loan of $10,000 when the APR is 9%.

Reference no: EM132246692

Questions Cloud

Importance to project success : What is quality and its importance to project success and how to explain quality management planning.
What is quality and its importance to project success : What is quality and its importance to project success and how to explain quality management planning
Compose a two paragraph description of hashing : Compose a two paragraph description of hashing that a non-technical user could understand.
Explain how to maintain confidentiality in care home setting : Promoting Effective Communication - Explain how to maintain confidentiality in the care home setting. Describe how to overcome barriers to communication
Calculate the total present value of the given cash flow : FINC 3733 Calculate the total present value of the following cash flows when the interest rate is 10% per year: $100 at the end of year 1.
Likert scale and the semantic differential scale : Compare and contrast the Likert scale and the semantic differential scale. Which scale is the most effective and why? Which scale do we see more often today?
Write the program that asks the user for a color : Write the program that asks the user for a color, a line width, a line length and a shape.
Benefits of the cloud to businesses : Describe cloud computing and the benefits of the cloud to businesses. Describe Iaas, Paas, and Saas. What are the differences between the three.
What role to you as an early child hood educator have : What are the benefits of quality child care on a child's development? In what ways does the Microsystems influence quality child care?

Reviews

Write a Review

Accounting Basics Questions & Answers

  What should tringali report as its income tax expense

For its first year of operations, Tringali Corporation's reconciliation. What should Tringali report as its income tax expense for its first year of operations?

  Describe the common uses of margin trading

Describe the procedures and regulations associated with margin trading. Be sure to explain restricted accounts, the maintenance margin, and the margin call.

  Develop a brief country risk assessment

Develop a brief country risk assessment. Determine the political, economic, social, and capital risks associated with doing business in China.

  Has the company paid cash dividends during the last

Has the company paid cash dividends during the last three years?

  What is the total variable cost of the product

What is the total variable cost of the product over the product life cycle

  Oklahoma manufacturing company uses a standard cost

oklahoma manufacturing company uses a standard cost accounting system. in 2012 the company produced 28200 units. each

  What is the unrealized gain and fair value adjustment

Hawk Corporation purchased 10,000 shares of Diamond Corporation stock in 2010 for $50 per share, What is the unrealized gain and fair value adjustment

  Income of the partnership

In the first year of the partnership, its cash-basis incom was $100,000, $50,000 of which was the collection of the transferred receivables. When is the income of the partnership reported and by whon?

  What is the difference between occupational fraud and abuse

What is difference between occupational fraud and occupational abuse? Discuss and provide examples. If you have an organizational anecdote, please provide it.

  Discuss what were the common aspects that were necessary

What were the common aspects that were necessary for the Enron and WorldCom debacles to occur

  Clark international produces designer watches each watch

clark international produces designer watches. each watch requires materials worth 14.50 and three direct labor hours.

  Compute depreciation for the second year

A company purchased a photocopy machine for $16,000. Compute depreciation for the second year under Straight-line method

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

Submit Assignment

Academics

Major Subjects

Majors

Get In Touch

whatsapp: +1-415-670-9521

Phone: +1-415-670-9521

Email: [email protected]

TERMS & POLICIES

HELP & SUPPORT

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd