Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

A company is preparing their 4th quarter cash summary budget. Based on their beginning cash balance and anticipated cash receipts and cash disbursements (payments), here

image text in transcribed

A company is preparing their 4th quarter cash summary budget. Based on their beginning cash balance and anticipated cash receipts and cash disbursements (payments), here are the ending cash balances initially planned each month. The balances shown below are BEFORE any borrowing of money or repayment of loans and interest. Management wants to keep a minimum cash balance of $20,412. Therefore, they will clearly need to borrow money in November. Luckily, December looks like a good month and they will have plenty of money to pay the loan back. Suppose their line of credit with the bank charges 12% interest annually. Assume if they borrow money in any month with a shortfall, they borrow it on the 1st day of the month. So you should assume they borrowed the money on the 1st day of November. If they pay money back in any one month, they will pay it back on the last day of the month. November December October Ending Cash Balance per the initial budget $23,935 plan analysis $13,245 $42,858 What will their final ending cash balance be as of December 31st after taking out the loan, paying back the loan and paying back the interest? Don't round any intermediate calculations. Round your answer to the nearest whole number

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Students also viewed these Accounting questions