Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Cash inflows Cash Collections Nov Deo Jan Feb Aar Mpr May In month of sales Month after sales Total cash collections begin{tabular}{rrrrrr} $ & 900

image text in transcribed
image text in transcribed
Cash inflows Cash Collections Nov Deo Jan Feb Aar Mpr May In month of sales Month after sales Total cash collections \begin{tabular}{rrrrrr} $ & 900 & $ & 925 & $ & 1,000 \\ $ & 50 & $ & 75 & $ & 100 \\ \hline$ & 950 & $ & 1,000 & $ & 1,100 \end{tabular} Cash Outflows Payments of materials purchases In month of purchase Month following purchase $$4501,250$$5001,300$550$1,350 Other cash payments SGA (monthly) Interest payments Total oash outflows \begin{tabular}{|crc|} \hline 1,200 & 1,200 & 1,200 \\ \hline & 750 & \\ \hline 800 & 1,450 & 850 \\ \hline \end{tabular} Net oash gain t floss) $150$(450)$250 Cash Flow Summary. \begin{tabular}{l|rr|rr} Cash balance at start of month & $ & 1,200 & $ & 375 \\ \hline Net oash gain t (loss) duting month & & 150 & & \end{tabular} Cash balance at end of month before financing Minimum oash balance desired Surplus t (deficit) oash \begin{tabular}{|rrr|} \hline 1,000 & 1,000 & 1,000 \\ \hline$ & 360 & \end{tabular} External Financing Summary External financing at start of month 25 New financing required Finanoing repayments External financing at end of month Cash balance at end of month after financing In the cash budget tab, what is Spacely's Sprockets's cash balance at the end of March

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

Fundamentals Of Investments Valuation And Management

Authors: Bradford Jordan, Thomas Miller, Steve Dolvin

9th Edition

1260013979, 9781260013979

More Books

Students also viewed these Finance questions