What is the present value of the cash flows

Reference no: EM13785077

Create a spreadsheet to solve the following problems.

Please number your answers clearly in bold or highlighted.

1. If I won a lump-sum lottery today which gave me $45,000 and I decided to put it into a 5 year investment earning an annual rate of 4%, how much would it be worth at the end of 5 years?

2. What if I decided to put my winnings in the same investment for 10 years?

Present Value

3. If I won a lump-sum lottery which promises to give me $45,000 5 years from now and the annual interest rate is 2%, how much would it be worth today (present value)?

4. What if the rate is 4%?

5. What is the present value of a car payment of $299 per month for 5 years with a 3.50% annual rate? (In other words, how much cash would it take today to buy the car outright instead of making monthly payments?)

6. What is the future value of a payment of $299 per month for 5 years with a 3.50% annual rate? (In other words, if you had put the monthly payments in the bank earning 3.50%, how much would it be worth at the end of 5 years?)

7. If I bought a house for $350,000 and mortgaged 80% of the cost using a 30-year loan at a fixed annual rate of 4.0%, what would my annual mortgage payment be?

8. What would my monthly mortgage payment be?

9. If you double your monthly mortgage payments from above, how long will it take to pay off your mortgage in months?

10. Why does doubling your monthly mortgage payment reduce the length of the loan by more than half?

Suppose your 7 year old daughter has announced that she would like to attend college. You believe it will cost $22,000 per year, for 4 years, for her to attend state college 11 years from now. You are giving yourself 11 years to save and assume you will earn 6% annually (inflation-adjusted) on your savings.

11. What is your savings goal (what must the account be worth 11 years from now)?

12. If you want to fund that savings goal with a one-time lump-sum today, how much would you need?

13. If instead of a one-time lump-sum, you contribute at the BEGINNING of each year, what must your annual payments be to reach the goal?

14. If instead of a one-time lump-sum, you contribute at the END of each year, what must your annual payments be to reach the goal?

15. What must your annual payments (at the end of each year) be if grandma decided to open the account with $5,000 today?

If you want to contribute annually to your IRA and you want your contribution to grow over time in the following way:

Year	Cash Flow
1	-1700
2	-2500
3	-3000
4	-4250
5	-4500
Interest Rate	7%

16. What is the present value of the cash flows?

17. What is the future value of the cash flows?

18. What is the Internal Rate of Return on these cash flows:

Year	Cash Flow
0	-14500
1	2800
2	3000
3	3500
4	4000
5	5000

19. If you have a choice between the investment in question #18, and a less risky project offering an annual rate of return of 11%, which would you choose?

20. If you borrowed $10,000 from a credit card which compounds interest continuously, and charges an annual rate of 23%, what would the balance (future value) be if you haven't paid anything towards the loan after 3 years?

Reference no: EM13785077

Questions Cloud

Create a vision statement for the organization : Create a vision statement and a mission statement for the organization? Explain how Joseph Dunn will create an organizational culture that supports his vision?

Short notes on analyze staffing challenges : Analyze Staffing Challenges.

Create a plan for improving the property in terms of safety : Create a plan of recommendations for improving the property in terms of safety, financial protection, and overall security. What benefits do you think would result from your proposed changes

Interference by central planners into family choices : How might this lead to further interference by central planners into family choices - What would be the effect of raising the price of gasoline in the United States to $5 per gallon?

What is the present value of the cash flows : What is the present value of the cash flows - What would my monthly mortgage payment be?

Problem related to the inventory valuations : From the e-Activity, examine the costs that Wal-Mart includes in inventory and cost of sales. Defend the three (3) descriptions that Wal-Mart used to classify inventories, and suggest two (2) other descriptions that Wal-Mart could include within t..

Describe the relative costs of each strategy : Describe the relative costs of each strategy

What is your opinion about the article darkened windows : What is my opinion about these 2 articles one is "Procrastination: Time Travel approach" and second is "Darkened Windows".

Minnesota department of health qi project : Demonstrate a clear understanding of HIT/QI acquisition, through its application in the Final Proposal.

User Account

All Pages