Prepare a cash budge by quarter for the year. What is the ending cash balance in the fourth quarter if interest is accrued until the end of the fourth quarter and paid at that time along with the total principal borrowed?

EBK CONTEMPORARY FINANCIAL MANAGEMENT
14th Edition
ISBN:9781337514835
Author:MOYER
Publisher:MOYER
Chapter16: Working Capital Policy And Short-term Financing
Section: Chapter Questions
Problem 21P
icon
Related questions
Question

A company has the following excess (deficiency) of cash receipts over cash disbursements projected for the next year on a quarterly basis. It will not have any cash at the start of the year. The quarterly interest rte is 2%, and any borrowing and repayment of principal must be in round $1,000 amounts. There is no cash reserve requirement Assume loan related payments are made when excess cash is available.

 

Quarter

 

1 2 3 4 Year

 

Excess (deficiency) of cash available for disbursements ($121,140) ($41,680) $177,680 $2,160 $17,020

 

Required:

 

Prepare a cash budge by quarter for the year. What is the ending cash balance in the fourth quarter if interest is accrued until the end of the fourth quarter and paid at that time along with the total principal borrowed?

 

Please provide detail calculations of how you got the cash available at the beginning. Thank you.

Expert Solution
steps

Step by step

Solved in 3 steps with 2 images

Blurred answer
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
EBK CONTEMPORARY FINANCIAL MANAGEMENT
EBK CONTEMPORARY FINANCIAL MANAGEMENT
Finance
ISBN:
9781337514835
Author:
MOYER
Publisher:
CENGAGE LEARNING - CONSIGNMENT
Financial Reporting, Financial Statement Analysis…
Financial Reporting, Financial Statement Analysis…
Finance
ISBN:
9781285190907
Author:
James M. Wahlen, Stephen P. Baginski, Mark Bradshaw
Publisher:
Cengage Learning
Corporate Fin Focused Approach
Corporate Fin Focused Approach
Finance
ISBN:
9781285660516
Author:
EHRHARDT
Publisher:
Cengage