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
