Individual Project Financial budgeting

profilejasonba012001
FINA425_U3_IP_StudentTemplate_2020.xlsx
Home>Business & Finance homework help>Operations Management homework help>Individual Project Financial budgeting

Sheet1

FINA425 UNIT 3 INDIVIDUAL ASSIGNMENT TEMPLATE
Student Name: ________________________
Date submitted: ________________________
Middletown Construction, Inc.
JANUARY FEBRUARY MARCH APRIL MAY JUNE JULY AUGUST SEPTEMBER OCTOBER NOVEMBER DECEMBER
SALES FORECAST 0 0 275,000 275,000 312,000 417,000 714,000 611,000 827,000 500,000 116,000 0
CASH COLLECTIONS
MONTH OF SALE 20%
FIRST MONTH AFTER SALE 60%
SECOND MONTH AFTER SALE 20%
TOTAL CASH INFLOWS $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0
JANUARY FEBRUARY MARCH APRIL MAY JUNE JULY AUGUST SEPTEMBER OCTOBER NOVEMBER DECEMBER
DIRECT MANUFACTURING COSTS - 0 - 0 220,000 240,000 225,000 287,000 350,000 415,000 242,000 214,000 222,000 - 0
PAYMENTS FOR RAW MATERIALS ARE
MANUFACTURING COST PAYMENTS
ADMINISTRATIVE SALARIES
LEASE PAYMENTS
MISCELLANEOUS
TAX PAYMENTS
NEW PLANT COSTS
TOTAL CASH OUTFLOWS $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0
MONTHLY NET CASH GAIN OR LOSS $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0
CUMULATIVE NET CASH GAIN OR LOSS (YTD) $ - 0 $ - 0 $ - 0
JANUARY FEBRUARY MARCH APRIL MAY JUNE JULY AUGUST SEPTEMBER OCTOBER NOVEMBER DECEMBER
CASH FLOW SUMMARY
1. Cash balance at start of month
2. Net cash gain (loss) during month
3. Cash bal. at end of month (before financing)
4. Minimum cash balance desired
5. Surplus cash (OR) Deficit cash (Line 3 - Line 4)
EXTERNAL FINANCING SUMMARY
6. External financing balance - start of month
7. New financing reqd (negative of Line 5) (if deficit!)
8. Financing repayments (if surplus!)
9. Ext financing balance - end of month
10.Cash bal at end of mo (Line3 + Line7 + Line8)
Developed by Patrice Nybro June 22, 2020

Sheet2

Sheet3