Answer- | ||||||
Cash outflow every year = $ 10,000 | ||||||
Rate of Interest = 5% |
||||||
Amount to be invested today will be the present value of future outflows, calculated as under | ||||||
No. Of years =20 | ||||||
Year |
Cash outflow (a) | PV factor (b) | PV( c= a/b) | |||
1 | $ 10,000 | 1.05000 | $ 9,523.81 | |||
2 | $ 10,000 | 1.10250 | $ 9,070.29 | |||
3 | $ 10,000 | 1.15763 | $ 8,638.38 | |||
4 | $ 10,000 | 1.21551 | $ 8,227.02 | |||
5 | $ 10,000 | 1.27628 | $ 7,835.26 | |||
6 | $ 10,000 | 1.34010 | $ 7,462.15 | |||
7 | $ 10,000 | 1.40710 | $ 7,106.81 | |||
8 | $ 10,000 | 1.47746 | $ 6,768.39 | |||
9 | $ 10,000 | 1.55133 | $ 6,446.09 | |||
10 | $ 10,000 | 1.62889 | $ 6,139.13 | |||
11 | $ 10,000 | 1.71034 | $ 5,846.79 | |||
12 | $ 10,000 | 1.79586 | $ 5,568.37 | |||
13 | $ 10,000 | 1.88565 | $ 5,303.21 | |||
14 | $ 10,000 | 1.97993 | $ 5,050.68 | |||
15 | $ 10,000 | 2.07893 | $ 4,810.17 | |||
16 | $ 10,000 | 2.18287 | $ 4,581.12 | |||
17 | $ 10,000 | 2.29202 | $ 4,362.97 | |||
18 | $ 10,000 | 2.40662 | $ 4,155.21 | |||
19 | $ 10,000 | 2.52695 | $ 3,957.34 | |||
20 | $ 10,000 | 2.65330 | $ 3,768.89 | |||
Total | $ 1,24,622.10 | |||||
Amount he should invest now is $ 1,24,622.10 | ||||||
i am using the tvm solver on the ti-84 plus. please do not use any formulas...
USING TVM SOLVER IN CALCULATOR ONLY (TI 83-84) plz show me how to do it in the calculator (TVM) Sarah secured a bank loan of $175,000 for the purchase of a house. The mortgage is to be amortized through monthly payments for a term of 15 years, with an interest rate of 3%/ year compounded monthly on the unpaid balance. She plans to sell her house in 5 years. How much will Sarah still owe on her house at that...
only A and D! math help please! if you can, please calculate using TVM solver on calculator. thank you! Question 4. I am trying to start saving for retirement. I am investing all my cash into the S&P 500, which we will assume consistently makes 9.8% interest, compounded annually (this is the average return over the past 90 years!). I initially put a lump sum of $100 into my account, and I will depost $10 every second week. (a) After...
TVM Assignment Please answer the questions in an excel spreadsheet with the formulas showing. Part IV: Retirement Planning You realize the wisdom of starting early at age 22 in saving for your retirement and plan on making 43 equal end of year annual deposits in an IRA account in hopes of having at least $1,000,000 once you retire at age 65 (immediately after your last deposit into the IRA account), but you think it would be best to have $1,500,000...
There are 7 steps to the question. Please advise what can I do to get all questions answered. I am ok with posting more than 1 questions for this problem as a whole. Please use excel and demonstrate the excel formule for the same. Case Study Description A $6M investment is considered by an electric bike manufacturing company to add a new production line for its new product, electric skateboards. The company has commissioned an exploratory study of where to...
please help answer these Financial Analysis Exercise #1 You are the newest Financial Analyst in Investments, you need to demonstrate your prowess in Excel, your outstanding written skills and ability to communicate. Mr. Richards is the Executive Vice President and Chief Investment officer in your new firm. You are being asked to complete a series of “pet” projects for Mr. Richards. You have been told not to try to impress him, just do the work and stick to the facts....
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...
Can someone please tell me what chapters (1-5) these questions are based on? I have already answered the questions and understand how to solve the material, but i want to be able to pinpoint where i can find this info. in the book. I am using Brigham’s Fundamentals of Financial Management (pictures attached). If it is hard to read, please let me know. i will post better pictures. i know the time vale of money stuff already EDIT: HERE IS...