A projected financial statement analysis seeks to forecast the impact of various implementation decisions. The pro forma financial statement can be part of the risk analysis of strategic plan. The goal of this assignment is to ensure your strategic plan is viable financially. In other words, does it create value for the firm? Consider the cost structure and revenue streams for your strategic initiative plan. Research and data collected so far and will likely change once your product or service is commercialized. Each statement should address financial components of features, expenses, and sales of your product or service. It is typical for net income to be negative at this point. Do not assume that you have sales at this point unless you have sold your product or service. Research the following since your plan is entrepreneurial: Balance sheet Income statement Statement of cash flow Fixed and variable expenses Startup expenses Breakeven analysisComplete the “Projected Financial Statement Analysis (Pro Forma 3-Year Financial Plan)”including the “Questions” tab, “12 Month P& L” tab, “Year 1” tab, “Year 2 P&L” tab, and “Year 3 P&L” tab. The first year is monthly and the second and third year are presented quarterly. Please note the questions in the “Questions” tab may be answered at different points in completing the Profit and Loss information.
projected_financial_statement_analysis.xlsx

copy_of_rubric_print_format.xlsx

Unformatted Attachment Preview

Projected Financial Statment Analysis (3-Year Financial Plan).
Questions
What is the vital financial information needed to
determine the viability of your plan ?
What ratios will you use to determine if the proposed
plan is a success?
What other, nonfinancial, information did you use to
put your plan together?
Consider the assumptions made when completing
Part 3. What assumptions are made? List the
assumptions that you used to formulate this plan.
Discuss the financial results from your Pro Forma
projections. Include the net income results, breakeven
analysis, and required expenses to commercialize your
product or service.
Explain how you would determine your pricing model.
What seems most appropriate for your business and
industry in which you will compete?
Identify your cost structure. Is your business model
cost-driven or value driven? Justify your selection.
Review your decision for a revenue model. Based on
the financial statements, will this model generate a
profit? Provide evidence to prove it.
Response
Additional considerations
Projected Financial Statment Analysis (3-Year Financial Plan).
Where are you getting capital to meet your strategic
initiative? What terms will be most likely deemed
acceptable?
Did you have to reevaluate (go back) why?
Profit and Loss Statement
Instructions
Give careful thought to the headings.
Expand the sales income and expenses area if your business has distinct categories (e.g. a restaurant may have food sales and beverage sales listed separately and cost of sa
One
Two
Three
Four
Five
Six
Seven
Eight
Nine
Month
Income
Sales
Sale of goods/services
Sundry Income (e.g. Commission
earned, frachise fees etc.)
Etc.
Total Sales
Less Discounts/Commissions
Sales Discounts given
Sales Commissions paid
Total Discounts/ Commissions
Total Net Income
Cost of Sales
Opening Stock
Stock Purchased
Less Closing Stock
Total Cost of Sales
Gross Profit
Expenses
General & Administrative
Bank charges
Credit card commission
Consultant fees
Office Supplies
License fees
Business insurance
Etc.
$

$

$

$

$

$

$

$

$

$
$
$

$
$
$

$
$
$

$
$
$

$
$
$

$
$
$

$
$
$

$
$
$

$
$
$

$
$
$

$
$
$

$
$
$

$
$
$

$
$
$

$
$
$

$
$
$

$
$
$

$
$
$

$

$

$

$

$

$

$

$

$

$
$
$
$

$
$
$
$

$
$
$
$

$
$
$
$

$
$
$
$

$
$
$
$

$
$
$
$

$
$
$
$

$
$
$
$

$

$

$

$

$

$

$

$

$

$

$

$

$

$

$

$

$

$

$
$
$
$
$
$
$

$
$
$
$
$
$
$

$
$
$
$
$
$
$

$
$
$
$
$
$
$

$
$
$
$
$
$
$

$
$
$
$
$
$
$

$
$
$
$
$
$
$

$
$
$
$
$
$
$

$
$
$
$
$
$
$

Total General & Administrative
Marketing & Promotional
Advertising
Promotion – General
Promotion – Other
Etc.
Total Marketing & Promotional
Operating Expenses
Newspapers & magazines
Parking/Taxis/Tolls
Entertainment/Meals
Travel/Accomodation
Laundry/dry cleaning
Cleaning & cleaning products
Sundry supplies
Equipment hire
Etc.
Total Operating Expenses
Motor Vehicle Expenses
Fuel
Vehicle service costs
Tyres & other replacement costs
Insurance
Registrations
Total Motor Vehicle Expenses
Website Expenses
Domain name registration
Hosting expenses
etc
Total Website Expenses
Employment Expenses
Permanent
Salaries/Wages
PAYE
Superannuation
$
12.00
$

$

$

$

$

$

$

$

$
$
$
$
$

$
$
$
$
$

$
$
$
$
$

$
$
$
$
$

$
$
$
$
$

$
$
$
$
$

$
$
$
$
$

$
$
$
$
$

$
$
$
$
$

$
$
$
$
$
$
$
$
$
$

$
$
$
$
$
$
$
$
$
$

$
$
$
$
$
$
$
$
$
$

$
$
$
$
$
$
$
$
$
$

$
$
$
$
$
$
$
$
$
$

$
$
$
$
$
$
$
$
$
$

$
$
$
$
$
$
$
$
$
$

$
$
$
$
$
$
$
$
$
$

$
$
$
$
$
$
$
$
$
$

$
$
$
$
$
$

$
$
$
$
$
$

$
$
$
$
$
$

$
$
$
$
$
$

$
$
$
$
$
$

$
$
$
$
$
$

$
$
$
$
$
$

$
$
$
$
$
$

$
$
$
$
$
$

$
$
$
$

$
$
$
$

$
$
$
$

$
$
$
$

$
$
$
$

$
$
$
$

$
$
$
$

$
$
$
$

$
$
$
$

$

$

$

$

$

$

$

$

$

$
$
$

$
$
$

$
$
$

$
$
$

$
$
$

$
$
$

$
$
$

$
$
$

$
$
$

Other – Employee Benefits
$
Recruitment costs
$
Total Perm. Employment Expenses
$
Casual
Salaries/Wages
$
PAYE
$
Superannuation
$
Other – Employee Benefits
$
Recruitment costs
$
Total Casual Employment Expenses
$
Workcover Insurance
$
Total Employment Expenses
$
Occupancy Costs
Electricity/Gas
$
Telephones
$
Property Insurance
$
Rates
$
Rent
$
Repair & maintenance
$
Waste removal
$
Water
$
Etc.
$
Total Occupancy Costs
$
Other Expenses
Add an expense description here $
Add an expense description here $
Add an expense description here $
Add an expense description here $
Add an expense description here $
Add an expense description here $
Add an expense description here $
Total Other Expenses
$
Total Expenses
$
Month Net Profit / (Loss)
$

$
$
$

$
$
$

$
$
$

$
$
$

$
$
$

$
$
$

$
$
$

$
$
$


$
$
$
$
$
$

$
$
$
$
$
$

$
$
$
$
$
$

$
$
$
$
$
$

$
$
$
$
$
$

$
$
$
$
$
$

$
$
$
$
$
$

$
$
$
$
$
$


$
$

$
$

$
$

$
$

$
$

$
$

$
$

$
$


$
$
$
$
$
$
$
$
$
$

$
$
$
$
$
$
$
$
$
$

$
$
$
$
$
$
$
$
$
$

$
$
$
$
$
$
$
$
$
$

$
$
$
$
$
$
$
$
$
$

$
$
$
$
$
$
$
$
$
$

$
$
$
$
$
$
$
$
$
$

$
$
$
$
$
$
$
$
$
$


$
$
$
$
$
$
$
$

$
$
$
$
$
$
$
$

$
$
$
$
$
$
$
$

$
$
$
$
$
$
$
$

$
$
$
$
$
$
$
$

$
$
$
$
$
$
$
$

$
$
$
$
$
$
$
$

$
$
$
$
$
$
$
$


$

$

$

$

$

$

$

$


$

$

$

$

$

$

$

$

Total Year to Date Net Profit /
(Loss)
$

$

$

$

$

$

$

$

$

parately and cost of sales for each also separated).
Ten
Eleven
Twelve
$

$

$

$
$
$

$
$
$

$
$
$

$
$
$

$
$
$

$
$
$

$

$

$

$
$
$
$

$
$
$
$

$
$
$
$

$

$

$

$

$

$

$
$
$
$
$
$
$

$
$
$
$
$
$
$

$
$
$
$
$
$
$

$

$

$

$
$
$
$
$

$
$
$
$
$

$
$
$
$
$

$
$
$
$
$
$
$
$
$
$

$
$
$
$
$
$
$
$
$
$

$
$
$
$
$
$
$
$
$
$

$
$
$
$
$
$

$
$
$
$
$
$

$
$
$
$
$
$

$
$
$
$

$
$
$
$

$
$
$
$

$

$

$

$
$
$

$
$
$

$
$
$

$
$
$

$
$
$

$
$
$

$
$
$
$
$
$

$
$
$
$
$
$

$
$
$
$
$
$

$
$

$
$

$
$

$
$
$
$
$
$
$
$
$
$

$
$
$
$
$
$
$
$
$
$

$
$
$
$
$
$
$
$
$
$

$
$
$
$
$
$
$
$

$
$
$
$
$
$
$
$

$
$
$
$
$
$
$
$

$

$

$

$

$

$

$

$

$

Profit and Loss Statement
Instructions
Give careful thought to the headings.
Expand the sales income and expenses area if your business has distinct categories (e.g. a restaurant may have food sales and beverage sales listed separately and cost of sale
Quarter
Income
Sales
Sale of goods/services
$
Sundry Income (e.g.
Commission earned, frachise
fees etc.)
$
Etc.
$
Total Sales
$
Less Discounts/Commissions
Sales Discounts given
$
Sales Commissions paid
$
Total Discounts/ Commissions $
Total Net Income
$
Cost of Sales
Opening Stock
$
Stock Purchased
$
Less Closing Stock
Total Cost of Sales
Gross Profit
Expenses
General & Administrative
Bank charges
Credit card commission
Consultant fees
Office Supplies
License fees
Business insurance
One
Two
Three
Four
Annual total

$

$

$

$


$
$
$

$
$
$

$
$
$

$
$
$


$
$
$

$
$
$

$
$
$

$
$
$


$

$

$

$

$
$

$
$
$
$

$
$
$
$

$
$
$
$

$
$
$
$

$

$

$

$

$

$

$

$

$

$

$
$
$
$
$
$

$
$
$
$
$
$

$
$
$
$
$
$

$
$
$
$
$
$

$
$
$
$
$
$

Etc.
$
Total General & Administrative $
Marketing & Promotional
Advertising
$
Promotion – General
$
Promotion – Other
$
Etc.
$
Total Marketing & Promotional $
Operating Expenses
Newspapers & magazines
$
Parking/Taxis/Tolls
$
Entertainment/Meals
$
Travel/Accomodation
$
Laundry/dry cleaning
$
Cleaning & cleaning products
$
Sundry supplies
$
Equipment hire
$
Etc.
$
Total Operating Expenses
$
Motor Vehicle Expenses
Fuel
$
Vehicle service costs
$
Tyres & other replacement costs $
Insurance
$
Registrations
$
Total Motor Vehicle Expenses $
Website Expenses
Domain name registration
$
Hosting expenses
$
etc
$
Total Website Expenses
$
Employment Expenses
Permanent
$
Salaries/Wages
$
PAYE
$
12.00
$
$

$
$

$
$

$
$


$
$
$
$
$

$
$
$
$
$

$
$
$
$
$

$
$
$
$
$


$
$
$
$
$
$
$
$
$
$

$
$
$
$
$
$
$
$
$
$

$
$
$
$
$
$
$
$
$
$

$
$
$
$
$
$
$
$
$
$


$
$
$
$
$
$

$
$
$
$
$
$

$
$
$
$
$
$

$
$
$
$
$
$


$
$
$
$

$
$
$
$

$
$
$
$

$
$
$
$


$

$

$

$


$
$

$
$

$
$

$
$

Superannuation
$
Other – Employee Benefits
$
Recruitment costs
$
Total Perm. Employment Expenses
$
Casual
Salaries/Wages
$
PAYE
$
Superannuation
$
Other – Employee Benefits
$
Recruitment costs
$
Total Casual Employment Expenses
$
Workcover Insurance
$
Total Employment Expenses $
Occupancy Costs
Electricity/Gas
$
Telephones
$
Property Insurance
$
Rates
$
Rent
$
Repair & maintenance
$
Waste removal
$
Water
$
Etc.
$
Total Occupancy Costs
$
Other Expenses
Add an expense description here $
Add an expense description here $
Add an expense description here $
Add an expense description here $
Add an expense description here $
Add an expense description here $
Add an expense description here $
Total Other Expenses
$
Total Expenses
$
Month Net Profit / (Loss)
$

$
$
$
$

$
$
$
$

$
$
$
$

$
$
$
$


$
$
$
$
$
$

$
$
$
$
$
$

$
$
$
$
$
$

$
$
$
$
$
$


$
$

$
$

$
$

$
$


$
$
$
$
$
$
$
$
$
$

$
$
$
$
$
$
$
$
$
$

$
$
$
$
$
$
$
$
$
$

$
$
$
$
$
$
$
$
$
$


$
$
$
$
$
$
$
$

$
$
$
$
$
$
$
$

$
$
$
$
$
$
$
$

$
$
$
$
$
$
$
$


$

$

$

$


$

$

$

$

Total Year to Date Net Profit /
(Loss)
$

$

$

$

$

Profit and Loss Statement
Instructions
Give careful thought to the headings.
Expand the sales income and expenses area if your business has distinct categories (e.g. a restaurant may have food sales and beverage sales listed separately and cost of sale
Quarter
Income
Sales
Sale of goods/services
Sundry Income (e.g. Commission
earned, frachise fees etc.)
Etc.
Total Sales
Less Discounts/Commissions
Sales Discounts given
Sales Commissions paid
Total Discounts/ Commissions
Total Net Income
Cost of Sales
Opening Stock
Stock Purchased
Less Closing Stock
Total Cost of Sales
Gross Profit
Expenses
General & Administrative
Bank charges
Credit card commission
Consultant fees
Office Supplies
License fees
Business insurance
One
Two
Three
Four
Annual total
$

$

$

$

$

$
$
$

$
$
$

$
$
$

$
$
$

$
$
$

$
$
$

$
$
$

$
$
$

$
$
$

$
$
$

$

$

$

$

$

$
$
$
$

$
$
$
$

$
$
$
$

$
$
$
$

$
$
$
$

$

$

$

$

$

$

$

$

$

$

$
$
$
$
$
$

$
$
$
$
$
$

$
$
$
$
$
$

$
$
$
$
$
$

$
$
$
$
$
$

Etc.
Total General & Administrative
Marketing & Promotional
Advertising
Promotion – General
Promotion – Other
Etc.
Total Marketing & Promotional
Operating Expenses
Newspapers & magazines
Parking/Taxis/Tolls
Entertainment/Meals
Travel/Accomodation
Laundry/dry cleaning
Cleaning & cleaning products
Sundry supplies
Equipment hire
Etc.
Total Operating Expenses
Motor Vehicle Expenses
Fuel
Vehicle service costs
Tyres & other replacement costs
Insurance
Registrations
Total Motor Vehicle Expenses
Website Expenses
Domain name registration
Hosting expenses
etc
Total Website Expenses
Employment Expenses
Permanent
Salaries/Wages
PAYE
$
$
12.00
$
$

$
$

$
$

$
$

$
$
$
$
$

$
$
$
$
$

$
$
$
$
$

$
$
$
$
$

$
$
$
$
$

$
$
$
$
$
$
$
$
$
$

$
$
$
$
$
$
$
$
$
$

$
$
$
$
$
$
$
$
$
$

$
$
$
$
$
$
$
$
$
$

$
$
$
$
$
$
$
$
$
$

$
$
$
$
$
$

$
$
$
$
$
$

$
$
$
$
$
$

$
$
$
$
$
$

$
$
$
$
$
$

$
$
$
$

$
$
$
$

$
$
$
$

$
$
$
$

$
$
$
$

$

$

$

$

$

$
$

$
$

$
$

$
$

$
$

Superannuation
$
Other – Employee Benefits
$
Recruitment costs
$
Total Perm. Employment Expenses
$
Casual
Salaries/Wages
$
PAYE
$
Superannuation
$
Other – Employee Benefits
$
Recruitment costs
$
Total Casual Employment Expenses
$
Workcover Insurance
$
Total Employment Expenses
$
Occupancy Costs
Electricity/Gas
$
Telephones
$
Property Insurance
$
Rates
$
Rent
$
Repair & maintenance
$
Waste removal
$
Water
$
Etc.
$
Total Occupancy Costs
$
Other Expenses
Add an expense description here $
Add an expense description here $
Add an expense description here $
Add an expense description here $
Add an expense description here $
Add an expense description here $
Add an expense description here $
Total Other Expenses
$
Total Expenses
$
Month Net Profit / (Loss)
$

$
$
$
$

$
$
$
$

$
$
$
$

$
$
$
$


$
$
$
$
$
$

$
$
$
$
$
$

$
$
$
$
$
$

$
$
$
$
$
$


$
$

$
$

$
$

$
$


$
$
$
$
$
$
$
$
$
$

$
$
$
$
$
$
$
$
$
$

$
$
$
$
$
$
$
$
$
$

$
$
$
$
$
$
$
$
$
$


$
$
$
$
$
$
$
$

$
$
$
$
$
$
$
$

$
$
$
$
$
$
$
$

$
$
$
$
$
$
$
$


$

$

$

$


$

$

$

$

Total Year to Date Net Profit /
(Loss)
$

$

$

$

$

Course Code
MGT-660
Class Code
MGT-660-O501
Criteria
Content
Percentage
100.0%
Questions
40.0%
Financials
40.0%
Language Use and Audience Awareness (includes
sentence construction, word choice, etc.)
10.0%
Mechanics of Writing (includes spelling,
punctuation, grammar, language use)
10.0%
Total Weightage
100%
Strategic Plan Part 5: Financials
Unsatisfactory (0.00%)
No response is given for each question.
The financial components are not provided.
Inappropriate word choice and lack of variety in language use
are evident. Writer appears to be unaware of audience. Use
of primer prose indicates writer either does not apply figures
of speech or uses them inappropriately.
Slide errors are pervasive enough that they impede
communication of meaning.
80.0
Less than Satisfactory (74.00%)
A response is given to most of the questions but contains
gaps. The responses do not forecast the impact of various
implementation decisions. Subject knowledge is unclear or
inconsistent.
The financial components are not provided however subject
knowledge is unclear or inconsistent.
Some distracting inconsistencies in language choice (register)
or word choice are present. The writer exhibits some lack of
control in using figures of speech appropriately.
Frequent and repetitive mechanical errors distract the
reader.
Satisfactory (79.00%)
A response is given to all of the questions with minimal detail
but no gaps. The level of analysis included in most of the
responses forecast the impact of various implementation
decisions. Some subject knowledge is evident.
The financial components are provided and some subject
knowledge is evident.
Language is appropriate to the targeted audience for the
most part.
Some mechanical errors or typos are present, but they are
not overly distracting to the reader.
Good (87.00%)
A response is given to all of the questions with detail. The
level of analysis included in most of the responses forecast
the impact of various implementation decisions. Subject
knowledge is competent.
The financial components are provided and subject
knowledge is competent.
The writer is clearly aware of audience, uses a variety of
appropriate vocabulary for the targeted audience, and uses
figures of speech to communicate clearly.
Slides are largely free of mechanical errors, although a few
may be present.
Excellent (100.00%)
A response is given to all of the questions with detail. The
level of analysis included in all of the responses forecast the
impact of various implementation decisions. Rationale
demonstrates comprehensive subject knowledge and
understanding.
The financial components are provided and demonstrates
comprehensive subject knowledge and understanding.
The writer uses a variety of sentence constructions, figures of
speech, and word choice in distinctive and creative ways that
are appropriate to purpose, discipline, and scope.
Writer is clearly in control of standard, written, academic
English.
Comments
Points Earned

Purchase answer to see full
attachment