Answered step by step
Verified Expert Solution
Question
1 Approved Answer
in 2nd picture profit) loss statement tamplate you can choose any balance sheet tamplate kindly answer it in detail in 2nd pic i show tamplate
in 2nd picture profit) loss statement tamplate you can choose any balance sheet tamplate kindly answer it in detail
in 2nd pic i show tamplate you don't see ?
this is full pic
For the proposed new product or service for your final project, create a Forecasted Profit/Loss Statement for the first year and a Balance Sheet. To access and download templates for each, follow the links below: Profit/Loss Statement Template Balance Sheet Template You will need to submit the Profit/Loss Statement and Balance Sheet for grading, as well as a one-page supplemental document that includes the background, rationale, and assumptions for the numbers included on the financials. Be sure to include the following: 1. Forecast Revenue for 12 months 2. Forecast Operating Expenses for 12 months 3. Calculation of the projected profit/loss for the first year 4. Documentation of the expected total assets and liabilities Company Name Twelve Month Fiscal Year JAN 2018 Profit & Loss Projection JAN-18 FEB-18 MAR-18 APR-18 MAY-18 JUN-18 COST OF SALES TREND Cost 1 $ 61 $ 78 $ 125 $ 45 Cost 2 $ 7 $ 65 $ 29 $ 69 $ 32 51 $ 90 $ 11 $ 30 Cost 3 $ 21 $ 34 Cost 4 $ 99 $ 95 $ 13 S 28 $ 34 $ 78 15 $ 84 $ 12 Cost 5 $ 43 $ 30 $ 77 $ 54 Profit loss statement Profit and loss Company Name Twelve Month Fiscal Year JAN 2018 Profit & Loss Projection JAN-18 FEB-18 MAR-18 APR-18 MAY-18 JUN-18 TREND COST OF SALES Costi Cost 2 $ 78 $ 45 $ 5 $ 11 $ 30 Cost 3 $ 61 65 $ 29 $ 125$ 7$ 69 $ 32 $ 99 $ 51 $ 90 $ 13 S 28 S 15 $ 8 $ 34 $ 43 $ 30$ 95 $ 21 $ 34 Cost 4 $ 84 $ 12 Cost 5 $ 78 $ 77 $ 54 Profit loss statement Excel For the proposed new product or service for your final project, create a Forecasted Profit/Loss Statement for the first year and a Balance Sheet. To access and download templates for each, follow the links below: Profit/Loss Statement Template Balance Sheet Template You will need to submit the Profit/Loss Statement and Balance Sheet for grading, as well as a one-page supplemental document that includes the background, rationale, and assumptions for the numbers included on the financials. Be sure to include the following: 1. Forecast Revenue for 12 months 2. Forecast Operating Expenses for 12 months 3. Calculation of the projected profit/loss for the first year 4. Documentation of the expected total assets and liabilities Company Name Twelve Month Fiscal Year JAN 2018 Profit & Loss Projection JAN-18 FEB-18 MAR-18 APR-18 MAY-18 JUN-18 COST OF SALES TREND Cost 1 $ 61 $ 78 $ 125 $ 45 Cost 2 $ 7 $ 65 $ 29 $ 69 $ 32 51 $ 90 $ 11 $ 30 Cost 3 $ 21 $ 34 Cost 4 $ 99 $ 95 $ 13 S 28 $ 34 $ 78 15 $ 84 $ 12 Cost 5 $ 43 $ 30 $ 77 $ 54 Profit loss statement Profit and loss Company Name Twelve Month Fiscal Year JAN 2018 Profit & Loss Projection JAN-18 FEB-18 MAR-18 APR-18 MAY-18 JUN-18 TREND COST OF SALES Costi Cost 2 $ 78 $ 45 $ 5 $ 11 $ 30 Cost 3 $ 61 65 $ 29 $ 125$ 7$ 69 $ 32 $ 99 $ 51 $ 90 $ 13 S 28 S 15 $ 8 $ 34 $ 43 $ 30$ 95 $ 21 $ 34 Cost 4 $ 84 $ 12 Cost 5 $ 78 $ 77 $ 54 Profit loss statement ExcelStep 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