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:
Total cost of Ticket = $96
Explanation:
Provided information,
Total number of people buying lottery ticket in a joint contribution = 10
Two people withdraw being short of funds, therefore people buying such ticket = 8
Revised share increase by $2.40 each.
Total increase = $2.40 8 = $19.20
Just because 2 people withdraw, thus earlier contribution per person = $19.20/2 = $9.60
Therefore, total cost of ticket = $9.60 10 = $96