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
THE COMPANY'S EARNING PER SHARE FOR THE YEAR WILL BE $2.30 PER SHARE.
Explanation:
FOR CALCULATING EARNING PER SHARE WE HAVE TO USED THE FOLLOWING FORMULA:
EARNING PER SHARE =
GIVEN:
NET INCOME = $9,660,000
NO. OF OUTSTANDING SHARE AT BEGINNING OF YEAR = 4,100,000
NO. OF OUTSTANDING SHARE AT END OF YEAR = 4,300,000
AS PER GIVEN FORMULA :
AVERAGE COMMON STOCK OUT STANDING = = 4200000 SHARES
NOW WE WILL FIND EARNING PER SHARE USING ABOVE FORMULA:
EARNING PER SHARE = $ 2.30 PER SHARE