Course Hero Logo

Revised_ 5-year financial plan - MASMAK GAMES.xlsx - Year 1...

Course Hero uses AI to attempt to automatically extract content from documents to surface to you and others so you can study better, e.g., in search results, to enrich docs, and more. This preview shows page 1 - 5 out of 17 pages.

Year 1 model inputs1. One-Year revenue expectancyCoinsSkinsin-app purchase ShopNumber of units sold annually50,000500500Average sales price per unit$10.00$10.00$10.00Annual revenue per product$500,000$5,000$5,000Total 1 year revenue$510,0002. Year 1 cost of goods soldCoinsSkinsin-app purchase Shop0Expected gross margin per product5.00%5.00%5.00%Annual cost of goods sold per product$25,000$250$250Total 1 year cost of goods sold$25,5003. Annual maintenance, repair, and overhaulFactor (%) on capital equipment1%4. Number of years for straight-line depreciation55. Annual tax rate15%$30,000Depreciable assestsBuildingsMachinery and equipment6. If long-term debt is being used to financeoperations, enter the total loan value.
Profit and loss projectionsYear-by-year profit and loss assumptionsYear 1Year 2Year 3Year 4Year 5Annual cumulative price (revenue) increase-25.00%20.00%30.00%30.00%Annual cumulative inflation (expense) increase-14.80%15.00%13.00%15.00%Interest rate on ending cash balance0.00%0.00%0.00%0.00%0.00%Year 1Year 2Year 3Year 4Year 5RevenueGross revenue$510,000$637,500$765,000$994,500$1,292,850Cost of goods sold (manufacturing cost)255,000318,750382,500497,250646,425Gross margin$255,000$318,750$382,500$497,250$646,425Other revenue [source]$0$0$0$0$0Interest income$0$0$0$0$0Total revenue$255,000$318,750$382,500$497,250$646,425Operating expensesSales and marketing$5,000$5,740$6,601$7,459$8,578Payroll and payroll taxes (salaries)10,000$11,480$13,202$14,918$17,156Depreciation00000Insurance1,500$1,722$1,980$2,238$2,573Maintenance, repair, and overhaul00000App and Web design20,000$22,960$26,404$29,837$34,312Property taxes0$0$0$0$0Administrative fees1,800$2,066$2,376$2,685$3,088Space Rental + Other0$0$0$0$0Total operating expenses$38,300$43,968$50,564$57,137$65,707Operating income$216,700$274,782$331,936$440,113$580,718Interest expense on long-term debt1,3461,075790490176
Operating income before other items$215,354$273,707$331,147$439,623$580,541Loss (gain) on sale of assets00000Other unusual expenses (income)00000Earnings before taxes$215,354$273,707$331,147$439,623$580,541Taxes on income15%32,30341,05649,67265,94387,081Net income (loss)$183,051$232,651$281,475$373,679$493,460Profit %55.99%57.47%58.21%60.19%61.73%
Balance sheet projectionsAssetsInitial balanceYear 1Year 2Year 3Year 4Year 5Cash and short-term investments$30,000$207,622$434,572$710,061$1,077,455$1,564,316Accounts receivable (Sales not yet paid)000000Total current assets$30,000$207,622$434,572$710,061$1,077,455$1,564,316Buildings$0$0$0$0$0$0Land000000Capital improvements000000Machinery and equipment000000Less: Accumulated depreciation expense000000Net property/equipment$0$0$0$0$0$0Goodwill$0$0$0$0$0$0Deferred income tax000000Long-term investments000000Deposits000000Other long-term assets000000Total assets$30,000$207,622$434,572$710,061$1,077,455$1,564,316Liabilities

Upload your study docs or become a

Course Hero member to access this document

Upload your study docs or become a

Course Hero member to access this document

End of preview. Want to read all 17 pages?

Upload your study docs or become a

Course Hero member to access this document

Term
Fall
Professor
NoProfessor

Newly uploaded documents

Show More

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture