Please find the key strokes below :-
N = 180
I = 0.3458
PV = 40000
FV = 0
Compute PMT = 298.88
I hope this helps
Took real efforts
Please press the like button
You graduated from the University of Toledo and are getting ready to enter the work force....
How much will your house be worth if it appreciates at 7% a year, you bought it for 200,000 and you expect to sell it in 5 years? PV Pmt Fv Rate 5 You purchase a car for $25,000 and amortize it over a 5 year period. Your payment is $456 per month. Assume the car is fully amortized at the end of the 5 years. What is your annual rate of interest? PV FV PMT Rate Monthly Rate Annual...
Advanced Time Value of Money Problems Question (Retirement planning) You have just graduated Hofstra University at age 22. You hard work has paid off as you already have a job as an investment banker at Goldman Sachs waiting for you. You plan to work continuously until age 65 and retire exactly on that day. You expect to live until exactly 90 and enjoy your golden years and leave you heirs NOTHING. Assume your investments earn 8% per year. You plan...
Show your work as much as possible below each question to get full credit (Le, you should provide information about PV: FV. PMT, I/Y, N ... before writing down your answer) 1. What is the present value of the following cash flow stream at a rate of 8.0%? Years: CFs: $2,450 $3,175 $4,400 2. You would like to travel in South America 5 years from now, and you can save $3,100 per year, beginning one year from today. You plan...
Problem 5-36 Suppose that you were to receive a $30,000 gift upon graduation from your master's degree program, when you turn 31 years old. At the end of each working year for 34 years, you put an additional $5,000 into an IRA a. Assuming you earn an annual compounded rate of 7.5 percent on the Rift and the IRA investments, how much would be available when you retire at age 65? b. If you hope to draw money out of...
Part 1: Planning Aheadwith Compound Interest Scenario: Suppose you have a new baby. You estimate that you need $ 100,000 for their college education when they are ready to go to college in 18 years. 1. Assume you invest $10,000 in a mutual fund (e.g. money market fund) atan APR of 7% compounded quarterly. How long, to the nearest tenth of a year, will it take the $10,000 to grow to $100,000?[Solve using both methods below.] Solve using Logarithmic Equations...
I need help on question 2.
MODULE IV: TIME VALUE OF MONEY INTRODUCTION The time value of money analysis has many a lysis has many applications, ranging from setting hedules for paying off loans to decisions about whether to invest in a partie financial instrument. First, let's define the following notations: I = the interest rate per period Na the total number of payment periods in an annuity PMT = the annuity payment made each period PV = present value...
Tony and Peggy Sue graduated from a university in Texas last May. She received a degree in elementary education, and he graduated from the culinary school. They both now work in the Dallas area. Peggy Sue is a teacher, and Tony is a chef at a resort hotel restaurant. It is Christmas Day and Tony asks Peggy Sue to marry him. She excitedly accepts. They set a wedding date of June 30. Tony is from New York City. He is...
You have graduated from college but unfortunately have $39,000 in outstanding loans. The loans require monthly payments of $268.33 (or $3,220 per year), which covers interest and principal repayment (that is, the loan has the same basic features as a mortgage). If the interest rate is 3 percent, how long will it take you to repay the debt? Use Appendix D to answer the question. Round your answer up to the next whole number. If the powers that be raise...
Use Excel (PV, FV, or PMT)
Let's say you are planning to purchase a house as soon as your student loans are paid off in 8 years. After graduation, you plan to live in an apartment for $820 a month and your dream is to buy a home worth $240,000 in 8 years. Once your debt is paid off, you will combine your apartment payment with your former debt payment to pay for the mortgage. That does not mean it...
Time Value of Money Spreadsheet Example 4 Module IV Name: Date: 6 7 8 Question 1 9 Question 2 10 Question 3 11 Question 4 12 Question 5 13 Question 6 14 Question 7 15 Question 8 16 Question 9 17 Question 10 18 19 20 Single Amount or Annuity 21 Periodic Interest Rate 22 Number of Periods 23 24 25 Present Value of Single Amount 26 27 Future Value of Single Amount 28 29 Future Value of An Annuity...