Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Crane Company is preparing a cash summary budget using the data below. They have already prepared their cash receipts and cash payments budget so that

Crane Company is preparing a cash summary budget using the data below. They have already prepared their cash receipts and cash payments budget so that data is provided:

October

November

Beginning Cash Balance

$16000

Expected Cash Receipts

$63000

$95000

Expected Cash Payments

$45000

$76000

Management always wants to maintain a $41,225 minimum cash balance at the end of every month. If there is an expected cash shortfall in the budget they will be proactive and borrow money at the first day of the month. That way they will not risk having too low of a balance during the month. They can borrow any amount of money needed. They may not pay loans back in installments. They have to pay them back all at once. The interest rate is 12%. Assume if they pay back money, they pay it back on the last day of the month.

What is the ending cash balance for November after all loan repayments of principle and interest?

Round your answer to the nearest whole dollar.

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

Recommended Textbook for

Accounting for Governmental and Nonprofit Entities

Authors: Earl R. Wilson, Jacqueline L Reck, Susan C Kattelus

16th Edition

78110939, 978-0078110931

More Books

Students also viewed these Accounting questions