Calculate the loan balance for each of the six months. The loan balance is calculated as the additional cash needed for a given
month minus any cash used to retire debt for that month plus the loan balance carried from the prior month.
1 answer:
Answer:
The closing balance from the excel sheet is $5,000.00
Explanation:
Solution
Given that:
The loan balance required l for each month can be computed as follows:
The loan balance = additional cash needed – cash used to retire debt + loan balance from previous month
Now
By applying the excel formula to perform this task is stated as follows:
D34 = SUM(D31-D33,C34)
The same formula is used to get the values for E34 to I34.
Kindly find an attached copy of the updated excel sheet after applying above formula which is a part of the solution is as follows:
You might be interested in
Answer:
$9.687
Explanation:
Given:
Year 3 dividend = $1.00
Year4&5 growth rate = 17%
Constant rate = 7%
Required return rate = 16%
Year 4 dividend wil be:
D4 = 1.00 * 1+growth rate
= 1.00 * (1+0.17)
= $1.17
Year 5 dividend=
D5 = $1.17 * (1+0.17)
= $1.3689
Value of stock after year 5 will be given as:
= $16.2747
For the current value of stock, we have:
Cv= Fd* Pv of discounting factor
Where Cv = current value of stock
Fd = future dividend
Pv = Present value of discounting factor
Therefore,
=$9.6871382455
≈ $9.687
The value of stock today =
$9.687