Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Your small company is good about maintaining a cash balance each month of at least $4,500. When actual net cash falls below that amount, you

Your small company is good about maintaining a cash balance each month of at least $4,500. When actual net cash falls below that amount, you tap a small line of credit at your bank; when actual cash is higher than that amount, you pay off some of any outstanding loan balance. (Last month, however, you ended with only $4,000.)

Given the information in the table below, complete the three-month cash budget for your firm.

Round all numbers to the nearest whole dollar and enter in the spaces without decimals or dollar signs; negative numbers should be enteredwith a simple minus sign (and no space). No credit is given for incorrect entries.

For example, calculated cash of $2,347.59 would be entered as 2348; a calculation of $(3,290) should be entered as -3290.

image text in transcribed
ACTUAL FORECAST Aug Sep Oct Nov Total cash $21600 $27450 $19500 receipts Total cash $24600 $23150 $22800 payments Net monthly $4300 $3300 cash flow Beginning cash $4000 $4500 $4500 balance Cumulative cash $1000 $8800 balance Monthly $ (borrowing) $3500 $3300 repayment Cumulative loan $1700 $900 $4200 balance Ending cash $4,000 $4500 $4500 balance

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

MATLAB An Introduction With Applications

Authors: Amos Gilat

6th Edition

111938513X, 978-1119385134

More Books

Students also viewed these Finance questions

Question

Evaluate the integral. dx s1 + |x|

Answered: 1 week ago