Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

can someone explain and give me the right answer Motors Corporation manufactures motors for dirt bikes. The company requires a minimum $30,000 cash balance at

can someone explain and give me the right answer
image text in transcribed
image text in transcribed
image text in transcribed
image text in transcribed
Motors Corporation manufactures motors for dirt bikes. The company requires a minimum $30,000 cash balance at each month-end. If necessary, the company borrows to meet this requirement at a cost of 3% interest per month (paid at the end o each month). Any preliminary cash balance above $30,000 at month-end is used to repay loans. The cash balance on July 1 $25,000, and the company has no outstanding loans. Budgeted cash receipts and budgeted cash payments (other than for interest on the loan and loan activity) follow. Prepare a cash budget for July, August, and September. Note: Negative balances and Loan repayment amounts (if any) should be indicate / with minus sign. Round your final answers to the nearest whole dollar. \begin{tabular}{|c|c|c|c|} \hline \multicolumn{4}{|c|}{ MOTORS CORPORATION } \\ \hline \multicolumn{4}{|c|}{ Cash Budget } \\ \hline & July & August & September \\ \hline Beginning cash balance & $25,000 & $30,000 & 30,000 \\ \hline Add: Cash receipts & 76,000 & 102,000 & 141,000 \\ \hline Total cash available & 101,000 & 132,000 & 171,000 \\ \hline \multicolumn{4}{|l|}{ Less: Cash payments for } \\ \hline Interest on loan & 00 & 990 & 6870 \\ \hline All items excluding interest & 104,000 & 90,900 & 118,400 \\ \hline Total cash payments & 104,000 & 91,890 & 119,087 \\ \hline Preliminary cash balance & (3,000) & 40,110 & 51,913 \\ \hline Additional loan (loan repayment) & 33,000 & (10,110) & (21,913) \\ \hline Ending cash balance & $30,000 & $30,000 & 30,000 \\ \hline \multicolumn{4}{|l|}{ Loan activity } \\ \hline Loan balance, beginning of Month & 02 & $33,000 & 22,890 \\ \hline Additional loan (loan repayment) & 33,000 & (10,110) & (21,913) \\ \hline Loan balance, end of month & $33,000 & $22,890 & 977 \\ \hline \end{tabular} Motors Corporation manufactures motors for dirt bikes. The company requires a minimum $30,000 cash balance at each month-end. If necessary, the company borrows to meet this requirement at a cost of 3% interest per month (paid at the end o each month). Any preliminary cash balance above $30,000 at month-end is used to repay loans. The cash balance on July 1 $25,000, and the company has no outstanding loans. Budgeted cash receipts and budgeted cash payments (other than for interest on the loan and loan activity) follow. Prepare a cash budget for July, August, and September. Note: Negative balances and Loan repayment amounts (if any) should be indicate / with minus sign. Round your final answers 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

Property Companies An Industry Accounting And Auditing Guide

Authors: Accountancy Books

1st Edition

1853558079, 978-1853558078

More Books

Students also viewed these Accounting questions

Question

6. Have you used solid reasoning in your argument?

Answered: 1 week ago