Question
These are the calculations that I created. My question is on the bottom. March April May June July August September October November Sales Forcast $100,000.00
These are the calculations that I created. My question is on the bottom.
March April May June July August September October November Sales Forcast $100,000.00 $275,000.00 $320,000.00 $450,000.00 $700,000.00 $700,000.00 $825,000.00 $500,000.00 $115,000.00 Current Month Payments $20,000.00 $55,000.00 $64,000.00 $90,000.00 $140,000.00 $140,000.00 $165,000.00 $100,000.00 $23,000.00 Previous Month Payments $60,000.00 $165,000.00 $192,000.00 $270,000.00 $420,000.00 $420,000.00 $495,000.00 $300,000.00 Payment from 2 months back $20,000.00 $55,000.00 $64,000.00 $90,000.00 $140,000.00 $140,000.00 $165,000.00 INCOME $20,000.00 $115,000.00 $249,000.00 $337,000.00 $474,000.00 $650,000.00 $725,000.00 $735,000.00 $488,000.00 Direct Manufactoring Cost $ (187,500.00) $ (206,250.00) $ (375,000.00) $ (337,500.00) $ (431,250.00) $ (640,000.00) $ (395,000.00) $ (425,000.00) Administration Salaries $ (35,000.00) $(35,000.00) $(35,000.00) $(35,000.00) $(35,000.00) $(35,000.00) $(35,000.00) $(35,000.00) $(35,000.00) Lease Payments $ (15,000.00) $(15,000.00) $(15,000.00) $(15,000.00) $(15,000.00) $(15,000.00) $(15,000.00) $(15,000.00) $(15,000.00) Depreicaition charges $ (15,000.00) $(15,000.00) $(15,000.00) $(15,000.00) $(15,000.00) $(15,000.00) $(15,000.00) $(15,000.00) $(15,000.00) One-time new plant investment $(95,000.00) Income tax payments $(55,000.00) $(55,000.00) Misc cost $ (10,000.00) $(10,000.00) $(10,000.00) $(10,000.00) $(10,000.00) $(10,000.00) $(10,000.00) $(10,000.00) $(10,000.00) EXPENSES $ (75,000.00) $ (262,500.00) $ (281,250.00) $ (600,000.00) $ (412,500.00) $ (506,250.00) $ (770,000.00) $ (470,000.00) $ (500,000.00) Cash on hand $50,000.00 $50,000.00 $50,000.00 $50,000.00 $50,000.00 $50,000.00 $50,000.00 $50,000.00 $50,000.00 $ (55,000.00) $ (147,500.00) $(32,250.00) $ (263,000.00) $61,500.00 $143,750.00 $(45,000.00) $265,000.00 $(12,000.00) Cash budget $ (55,000.00) $ (202,500.00) $ (234,750.00) $ (497,750.00) $ (436,250.00) $ (292,500.00) $ (337,500.00) $(72,500.00) $(84,500.00)
Above is my interpretation of this assignment. How do I figure out the cash budget?
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started
Fundamentals of Financial Management
Authors: Eugene F. Brigham, Joel F. Houston
11th edition
324422870, 324422873, 978-0324302691
