Answered step by step
Verified Expert Solution
Link Copied!

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.
image text in transcribed
image text in transcribed
image text in transcribed
image text in transcribed
image text in transcribed
image text in transcribed
image text in transcribed
image text in transcribed
image text in transcribed
image text in transcribed
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

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

Bitcoin Technical Innovations From The Trenches

Authors: Sjors Provoost

1st Edition

9090360425, 978-9090360423

More Books

Students also viewed these Finance questions

Question

=+1. Determine the purpose.

Answered: 1 week ago

Question

=+a. Describe the flaws you discovered in this blog post.

Answered: 1 week ago

Question

=+5. Choose between direct and indirect approaches.

Answered: 1 week ago