Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Can you show steps please. I have already started on the problem, so I don't know if all my answers are correct. The monthly cash
Can you show steps please. I have already started on the problem, so I don't know if all my answers are correct.
The monthly cash budgets for the second quarter of 2019 follow ($000 omitted) for Forest Hills Mfg. Co. A minimum cash balance of $18,000 is required to start each month, and a $50,000 line of credit has been arranged with a local bank at a 11% interest rate. Required: Calculate the missing amounts. (Hint: The total cash available includes collections from customers for all three months, plus the beginning cash balance from April 1, 2019.) (Enter your answers in thousands rounded to 2 decimal places. (i.e., 20,550 should be entered as 20.55). Use 360 days a year for calculations.) May June Total April $ 24.00 Cash balance, beginning $ 18.00 $ 18.00 $ 24.00 Add collections from customers $ 66.00 $ 105.00 $ 135.00 $ 306.00 Total cash available $ 90.00 $ 123.00 $ 153.00 $ 330.00 $ 48.00 $ 61.00 $ 50.00 $ 125.00 $ 30.00 $ 36.00 $ 126.00 $ 36.00 $ 8.00 $ 46.00 $ 9.00 Less disbursements: Purchase of inventory Operating expenses Capital additions Payment of dividends Total disbursements Excess (deficiency) of cash available over disbursements Borrowings Repayments (including interest) Cash balance, ending $ 114.00 $ 105.00 $ 87.00 $ 306.00 $ (24.00) $ 18.00 $ 66.00 $ 24.00 $ 42.00 $ 18.00 $ 18.00 $ 22.85Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started