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:
Answer:
The month of April
Explanation:
Susan Zupan, a lawyer, accepts a legal engagement in March, performs the work in April, and is paid in May. If Zupan's law firm prepares monthly financial statements, the law firm should recognize the revenue in April because according to revenue recognition principle, revenue should be recognized in the accounting period in which services are performed, and Susan zupan performed the work in April so therefore the firm should recognize the revenue in April.