Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Financials (Topic 6) A projected financial statement analysis seeks to forecast the impac... Part 5: Financials (Topic 6) A projected financial statement analysis seeks to

Financials (Topic 6) A projected financial statement analysis seeks to forecast the impac... Part 5: Financials (Topic 6) 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 if your plan is entrepreneurial: Balance sheet Income statement Statement of cash flow Fixed and variable expenses Startup expenses Breakeven analysis Research the following if your plan is a market expansion plan for an existing organization, or a mergers and acquisitions plan: Balance sheet Income statement Statement of cash flow Fixed and variable expenses A projected budget Breakeven analysis Complete 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. I Need the First One to Have Profit and Loss Income Sales Sales of Goods Sundry Income ETC Total Sales Less Discounts/Commissions- Sales Discount Given -Sales Commission paid- Total Discounts/commissions Total Net Income Cost of Sales- Opening stock-stock Purchased-Less closing stock -Total closing stock Gross Profit Expenses General and Adminstrative - Bank charges, Credit card commission, consultant fee, office supplies, license fees, business Insurance ETC -Total General and Administrative Marketing Promotional- Advertising, promotion general, promotion other, ETC- Total Marketing And Promtotional Operating Expenses- Newspaper, parking/Taxis/Tolls, Entertainment Meals, Travel/Accomdation, Laundry/Dry Cleaning, Cleaning and cleaning products, Sundry Supplies, Equipment Hire, ETC Total Operating Expense Motor Vechicle Expense- Fuel, Vechicle service costs, Tryes and other replacement costs, Insurance, Registrations, Total Motor Vechicle Expense Website Expense- Domain name registration, Hosting expenses- Total Website Expense Employment Expense- Salaries/wages, PAYE, Superannuation, other Employee Benefits, Recuriment Cost Total Per. Employment Expense Casual Employment Expense- Salaries, PAYE, Superannuation, Other Employee Benefits, Recuriment costs Total Casual Employment Expense Work cover Insurance Total Employment Expense Occupancy Cost- Electric/Gas, Telephones, Property Insurance, Rates, Rent, Repair and Maintance, Waste Removal, Water- Total Occupancy Costs Other Expenses Total other Expense Total Expense Month Net Profit/ (LOSS) Total year to date net Profit/(LOSS) I am Doing this on Coke Cola for the years 2017 For the Profit And Loss Statement I am doing this second On for 2 years Quarterly Report for 2016 2015 The third one IS Quarterly for 3 years for 2014 2013 2012 I need all of this

Yes you can use coke colas report

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

Cost-Benefit Analysis

Authors: E.J. Mishan, Euston Quah

6th Edition

1138492752, 978-1138492752

More Books

Students also viewed these Accounting questions