Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Your financial plan should include your 5-year projected business financials including your proforma income statement, balance sheet, and cash flow statement to clearly illustrate your
Your financial plan should include your 5-year projected business financials including your proforma income statement, balance sheet, and cash flow statement to clearly illustrate your companys revenue and profitability model.
Dear Student,
To help you, I developed a template for Pizza Company, and I added my numbers such as:
Initial investment = $ 2,500,000
Purchase a property for $ 1,250,000
The oven cost $ 250,000
Furniture and fittings $ 75,000
I am producing 100,000 Pizza within a year.
Please note these are my numbers for "Mape Pizza", so you can use the template and use your values.
First, could you look at the Key values to understand my budgeted income statement?
And five-year investment analysis template.
just do me the spreedsheet here and ill pay the rest deal ?
Mape Pizza Initial investment is $2500,000; the Purchased property is $1250,000, Furniture na fittings are 7 . is $250,000 with a depreciation of 20%. 1 . 1 Revenue Budget RMir Classification: Trusted 3 Direct Material Budget Beginning direct material inventories and costs per units ae as follows: A nienatiols..n.1. 5 Manufacturing overhead budget (Variable and fixed overheads) Variable ovehead (cost per unit): Supplies: \$1 (supp. Indire la and Maint) Total variable cost per unit 1.00 Fixed Manufacturing Overhead cost (FMOHC) FMOHC includes following DepesiationProprtyratesInsuerenceMiscellaneousTotalFMOHC$$$$$50,0005,0005,0001,50061,500 FMOC per unit Aveage Unit cost of Pizza $0.62$10.57 \begin{tabular}{|l|l|lr|} \hline \multicolumn{2}{|c|}{ Manufacturing Overhead Budget } & \\ \hline Variable manufacturing OH costs & & \\ \hline Supplies & & $ & 50,000 \\ \hline Indirect labour & & $5 & 25,000 \\ \hline Maintenance & & $ & 25,000 \\ \hline Total variable OH & & $ & 100,000 \\ \hline Fixed Manufacturing OH costs & & & \\ \hline Depreciation & $ & 50,000 & \\ \hline \end{tabular} 6 Cost of goods sold budget RMAlT Classification:Trusted RMIT Classification: Trusted NCL Capital Invested capital Net profit $$2,500,000289,450 Total liability $2,913,500$ RMeiT chassitication:Trusted Mape Pizza Initial investment is $2500,000; the Purchased property is $1250,000, Furniture na fittings are 7 . is $250,000 with a depreciation of 20%. 1 . 1 Revenue Budget RMir Classification: Trusted 3 Direct Material Budget Beginning direct material inventories and costs per units ae as follows: A nienatiols..n.1. 5 Manufacturing overhead budget (Variable and fixed overheads) Variable ovehead (cost per unit): Supplies: \$1 (supp. Indire la and Maint) Total variable cost per unit 1.00 Fixed Manufacturing Overhead cost (FMOHC) FMOHC includes following DepesiationProprtyratesInsuerenceMiscellaneousTotalFMOHC$$$$$50,0005,0005,0001,50061,500 FMOC per unit Aveage Unit cost of Pizza $0.62$10.57 \begin{tabular}{|l|l|lr|} \hline \multicolumn{2}{|c|}{ Manufacturing Overhead Budget } & \\ \hline Variable manufacturing OH costs & & \\ \hline Supplies & & $ & 50,000 \\ \hline Indirect labour & & $5 & 25,000 \\ \hline Maintenance & & $ & 25,000 \\ \hline Total variable OH & & $ & 100,000 \\ \hline Fixed Manufacturing OH costs & & & \\ \hline Depreciation & $ & 50,000 & \\ \hline \end{tabular} 6 Cost of goods sold budget RMAlT Classification:Trusted RMIT Classification: Trusted NCL Capital Invested capital Net profit $$2,500,000289,450 Total liability $2,913,500$ RMeiT chassitication:Trusted 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