EAR = 15.6% so monthly interest rate = (1+ 15.6%)^(1/12) - 1 = 1.215%
Calculate the present value of the 1st stream of payments ie. from month 1 to month 56:
P = 375; g = 6%; r = 1.215%; n = 56
Using PV of growing annuity formula
PV = 375/(1.215% - 6%) [ 1- ((1+6%)/(1+1.215%))^56] = 96,276.25
Now, this is the PV for the 1st cash flow stream. 2nd cash flow stream will have a PV of 96,276.25*(1+13%) at the end of month 56, and so on, till perpetuity. It can be represented as shown below, growing at 13% every 56 months:
Months (m) | 0 | 56 | 112 | 168 |
PV of cash flow stream | 96,276.25 | 108,792.17 | 122,935.15 | 138,916.72 |
Discount rate for 56 months d = (1 + 1.215%)^56 -1 = 96.70%
PV of cash flow streams from month 56 onwards = CF56/(d - 13%)
= 108,792.17/(96.70% - 13%) = 129,979.49
Total PV = 96,276.25 + 129,979.49 = 226,255.75 (option E)
i really need help with this iu FINS1613 The Perpetuity of Broken Dreams Practice Problem Question 1 The Perpetuity Of Broken Dreams is an investment that pays monthly cash The first payment of $3...
hii! i need help with requirements 6-8 PROBLEME 9,000 900 Objective The objective of Problem 3 is to reinforce your understanding of the preparation of budgets 16,800 Operating and Financial Budgets. Lynn has become concerned about the cash needs for th e cows. You have been asked to prepare some budgets related to the production and sales of water bottles for the first quarter of 2020: the three months of January February and March and the quartier in total Lyrwald...
I JUST NEED HELP WITH QUESTION 2 CASH FLOW CONCERNS Three months ago Harding had prepared a cash flow forecast for the period October 1995 to May 1996. November through March is generally a slow period for the resort, and it is not unusual for the lodge to run cash deficits during most, if not all, of these months. However, the cash surplus generated during the peak period, from August through October, is typically sufficient to meet the shortfall. This...
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...
5. Tommy is going to receive a cash flow of 5100 monthly for 15 years. Timmy w poing to receive a cash flow of $100 monthly forever. If the discount is 125. how cho Jimmy's cash flow worth as of today? A) $1.294.36 B) $1.323.57 C) $1,545.4) D) $1,667.83 D 57.493 83 6. You have just obtained the loan in the mount of $10.000 You make monthly payment of 53226719 for 3 years. What is the quoted interest rate on...
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...
Please read the facts of the case and prepare answers for the following questions : 1 – What is the relevance of the $2,000 monthly payment to Dave Verden on the analysis of Jones’ financing needs? 2 – What metrics could you use to compare the historical financial results for Jones with the projected financial results under the four defined scenarios? 3 – Other than financing needs, what other issues should Jones address as he considers the different growth scenarios?...