have a little confusing about setting this up in the right areas

wert Page Layout Formulas Data e Home s Xan Review View Help Tell me what you want to do Uncom General - Forma B1 V . . A E Merge & Centet. 5.%9 8 -28 Clipboard Font L M N O PEYTON APPROVED PRO ROMA INFORMATION The company is planning to open another location in 2018. Prepare pro forma financials for 2018 for the new location using the following information 1. Cost of leasing commercial space: $1,500 per month 2. Cost of new equipment: $15,000, purchased with a long term note. Use straight line depreciation assuming a seven year life, no residual value. Use full year's depreciation for the first year. Equipment purchase was financed with a 3. Cost of hiring and training new employees three at $25,000 each for the first year. 4. Except as noted below in 1, 2, 3, and 5, assets, current liabilities, sales, costs, and expenses are expected to be 80% of the existing store (from preliminary statements) except no stock. Retained earnings net income 5. Cash: $7,000. Accounts receivable amount to 4.0 turns (accounts receivable turnover will be 4.0 Inventory amount to show 3.0 turns inventory turnover will be 3.0). No stock will be issued. Retained earnings are to equal net income Additional financing of $5,000 will be long-term Add remaining amount needed to balance into accounts payable. 999 CF 2017 Revised Balance sheet 2015 Balance sheet 2015 Bnce Sheet 2016 Balance Sheet 2016 Income Statement 2016 Ratio Analysis Milestone 2 Instructions Type here to search - w E RT Y UI O P - 11 final 2.0 - Excel le Home Page Layout Term Date Review View Help Tell me what you want to do STV O .A + Mg Can . 5. Conditional Format Cell Formatting the Styles Peyton Approved Income Statement For Year Ended 12/31/2017 $ 327 2.55 1 206 64 Bakery Sales Merchandise Sales Total Revenues Cost of Goods Sold-Baked Cost of Goods Sold Merchandise Total Cost of Goods Sold Gross Profit 328,528.19 105.834 29 85977 108,69406 221 834.13 Operating Expenses Rent Expense Wages Expense Me Supplies Expense 24.560 19 10.670 72 3000 46 245 77 n ce Sheet 2017 con Statement 2017 ved he SSD Retained Earnings 2017 2017 Type here to search 5 D F G H J K * C v BNL final 2.0 - Excel The Home mont Page Layout Formular Data Review View Hop e Tell me what you want to do nxa = 12 - AA O. A WpTot Mega Center - - Format Paint BTW- Accounting S . % 9 Gross Profit 221,834.13 Operating Expenses Rent Expense Wages Expense Mise Supplies Expense Business License Expense Mise Expense Depreciation Expense Insurance Expense Advertising Expense Interest Expense Telephone Expense Total Operating Expenses: 2454919 10.670.72 3000 46 2045 77 1,36384 677 86 1,091 08 1,549.74 818 31 490 98 Net Income 46,257.95 176,576.18 dh e Sheet 2017 Income Statement 2017 P hee to search Rene 2017 hp M wert Page Layout Formulas Data e Home s Xan Review View Help Tell me what you want to do Uncom General - Forma B1 V . . A E Merge & Centet. 5.%9 8 -28 Clipboard Font L M N O PEYTON APPROVED PRO ROMA INFORMATION The company is planning to open another location in 2018. Prepare pro forma financials for 2018 for the new location using the following information 1. Cost of leasing commercial space: $1,500 per month 2. Cost of new equipment: $15,000, purchased with a long term note. Use straight line depreciation assuming a seven year life, no residual value. Use full year's depreciation for the first year. Equipment purchase was financed with a 3. Cost of hiring and training new employees three at $25,000 each for the first year. 4. Except as noted below in 1, 2, 3, and 5, assets, current liabilities, sales, costs, and expenses are expected to be 80% of the existing store (from preliminary statements) except no stock. Retained earnings net income 5. Cash: $7,000. Accounts receivable amount to 4.0 turns (accounts receivable turnover will be 4.0 Inventory amount to show 3.0 turns inventory turnover will be 3.0). No stock will be issued. Retained earnings are to equal net income Additional financing of $5,000 will be long-term Add remaining amount needed to balance into accounts payable. 999 CF 2017 Revised Balance sheet 2015 Balance sheet 2015 Bnce Sheet 2016 Balance Sheet 2016 Income Statement 2016 Ratio Analysis Milestone 2 Instructions Type here to search - w E RT Y UI O P - 11 final 2.0 - Excel le Home Page Layout Term Date Review View Help Tell me what you want to do STV O .A + Mg Can . 5. Conditional Format Cell Formatting the Styles Peyton Approved Income Statement For Year Ended 12/31/2017 $ 327 2.55 1 206 64 Bakery Sales Merchandise Sales Total Revenues Cost of Goods Sold-Baked Cost of Goods Sold Merchandise Total Cost of Goods Sold Gross Profit 328,528.19 105.834 29 85977 108,69406 221 834.13 Operating Expenses Rent Expense Wages Expense Me Supplies Expense 24.560 19 10.670 72 3000 46 245 77 n ce Sheet 2017 con Statement 2017 ved he SSD Retained Earnings 2017 2017 Type here to search 5 D F G H J K * C v BNL final 2.0 - Excel The Home mont Page Layout Formular Data Review View Hop e Tell me what you want to do nxa = 12 - AA O. A WpTot Mega Center - - Format Paint BTW- Accounting S . % 9 Gross Profit 221,834.13 Operating Expenses Rent Expense Wages Expense Mise Supplies Expense Business License Expense Mise Expense Depreciation Expense Insurance Expense Advertising Expense Interest Expense Telephone Expense Total Operating Expenses: 2454919 10.670.72 3000 46 2045 77 1,36384 677 86 1,091 08 1,549.74 818 31 490 98 Net Income 46,257.95 176,576.18 dh e Sheet 2017 Income Statement 2017 P hee to search Rene 2017 hp M