need help calculating units sold per year, a income statement each year and trend analysis in excel base year is 2017

I need a formal multi step income statement for each year, included with detailed cost of goods sold section, and trend percentages for growth in sales and in net income from base year 2017

ne t of model planes. The firm Accounting 11 Spreadsheet Assignment Portion of in-Class Writing Activity Name COMPANY: TIME TO PLAY, INC. Date You are a member of top manageme n ea originally operated as a sole proprietorship, but rece a as a sole proprietorship but recently chanand to the corporate form in hopes of penang operations by generating acti financing from the sale of common stock You and n g from the sale of common omer top managers will be mai t h the new Board of Director background information on the busines s pro s ince its inception in To just got off the phone with the f a ccount Randi Hunter who was her way to a hospital for treatment of h u man Could you determine the CEO Galen Carter who will be mange profitability information for the s thoroughly enjoyed the accounting courses presentation to the Board of Director t y determination and feel confident in your you look in college you remember much bet ability to help out Y Because of competition, the company has had to drop selling prices. The selling price per unit was 58 85 in 2017. $6.75 in 2018 and 56.70 in 2019 Then there is the issue of product costs versus period expenses. There has not been much inflation the past few years, so product costs as opposed to period expenses) have been stable Searching through files in Randis office you find that since 2017 Time To Play Inc has had the following manufactured cost per unit for all three years Direct Materials Per Unit S1 10 Direct Labor Per Unit Overhead Applied Per Unit 235 In addition the firm incurred selling and administrative costs that are considered period expenses Other numancal data can be summarized as follows Selling and e nved Units Manufactured Units Sold Units in End InvenAdmin Expenses 2017 118.000 18,000 $ 52,000 290,000 66.000 $106.800 320,000 114.000 $127.600 be that although this new corporation will have to pay income taxes on the income it pontorship it was for those three years) did not because sole propnetorship 's income on their personal tax returns). Finally, you remind yourself that to have to consider the difference between expired and unexpired costs ROURED Prepare a spreadsheet with appropriate INPUT and OUTPUT sections les al number of units sold each year (for 2017, 2018, and 2019). formal multiple step income statement for each year (be sure it also doost of goods sold section), and (c) calculate trend (or horizontal), growth in sales and in net income from the base year of 2017 Accounting 11 Spreadsheet Assignment Portion of In-Class Writing Activity COMPANY: TIME TO PLAY, INC. Name: Date: You are a member of top management of Time To Play Inc a seller of model airplanes The originally operated as a sole proprietorship, but recently changed to the corporate form in hopes of expanding operations by generating additional financing from the sale of common stock. You and other top managers will be meeting next week with the firm's new Board of Directors to provide background information on the business and detail its profitability since its inception in 2011 You just got off the phone with the firm's comptroller (chief accountant), Randi Hunter, who was on her way to a hospital for treatment of her worsening pneumonia. Could you determine the profitability information for the Chief Executive Officer (CEO) Galen Carter, who will be making the presentation to the Board of Directors? Because you thoroughly enjoyed the accounting courses you took in college, you remember much about profitability determination and feel confident in your ability to help out Because of competition, the company has had to drop selling prices. The selling price per unit was $6.85 in 2017. $6.75 in 2018, and $6.70 in 2019. Then there is the issue of product' costs versus "period' expenses. There has not been much inflation the past few years, so product costs (as opposed to period expenses) have been stable Searching through files in Randi's office, you find that since 2017. Time To Play, Inc. has had the following manufactured cost per unit for all three years Direct Materials Per Unit $1.10 Direct Labor Per Unit 15 Overhead Applied Per Unit 235 In addition, the firm incurred selling and administrative costs that are considered period expenses. Other numerical data can be summarized as follows: Selling and Year Units in Bea inven Units Manufactured Units Sold Units in EndInver Admin Expenses 2017 118,000 18.000 $ 52,000 2018 290,000 66,000 $106.800 2019 320.000 114,000 $127,600 Remember that although this new corporation will have to pay income taxes on the income it enerates the sole proprietorship it was for those three years) did not because sole proprietorship were report the firm's income on their personal tax returns). Finally, you remind yourself that to calculate profit you will have to consider the difference between expired and unexpired costs REQUIRED Prepare a spreadsheet with appropriate INPUT and OUTPUT sections that calculates (a) number of units sold each year (for 2017, 2018, and 2019). b) prepares a formal multiple-step income statement for each year (be sure it also includes a detailed cost of goods sold section), and (c) calculate trend (or horizontal) percentages for growth in sales and in net income from the base year of 2017 Accounting 11 Name: Spreadsheet Assignment Portion of in-Class Writing Activity COMPANY: TIME TO PLAY, INC. Date You are a member of top management of Time To Play, Inc., a seller of model airplanes. The form ongmany operated as a sole proprietorship, but recently changed to the corporate form in nope expanding operations by generating additional financing from the sale of common stock You and other top managers will be meeting next week with the firm's new Board of Directors to provide background information on the business and detail is profitability since its inception in 20 Tou just got off the phone with the firm's comptroller (chief accountant). Randi Hunter who was on her way to a hospital for treatment of her worsenina pneumonia Could you determine the profitability information for the Chief Executive Officer (CEO) Galen Carter, who will be making the presentation to the Board of Directors? Because you thoroughly enjoyed the accounting courses you took in college, you remember much about profitability determination and feel confident in your ability to help out Because of competition, the company has had to drop selling prices. The selling price per unit was 56.85 in 2017, 56.75 in 2018 and 56.70 in 2019. Then there is the issue of product costs versus penod expenses. There has not been much inflation the past few years. So product costs opposed to period expenses) have been stable Searching through files in Randi's office you find that since 2017. Time To Play, Inc has had the following manufactured cost per unit for all three years Direct Materials Per Unit $1.10 Direct Labor Per Unit 15 Overhead Applied Per Unit 2.35 In addition, the firm incurred selling and administrative costs that are considered period expenses Other numerical data can be summarized as follows Selling and Year Unin g Inven t Manufactured Units Sold Units in End Inven Admin Expenses 2017 118,000 18,000 $ 52,000 2018 290.000 65,000 $106.800 2019 320,000 114.000 5127,600 Remember that although this new.corporation will have to pay income taxes on the income it the sole proprietorship it was for those three years) did not because sole proprietorship p ort the firm's income on their personal tax returns). Finally, you remind yourself that to al p ot you will have to consider the difference between "expired" and "unexpired" costs REQUIRED Prepare a spreadsheet with appropriate INPUT and OUTPUT sections a tes a number of units sold each year (for 2017, 2018, and 2019). b e a formal multiple-step income statement for each year (be sure it also detailed cost of goods sold section) and (c) calculate trend (or horizontal) for growth in sales and in net income from the base year of 2017 O r