give me the excel sheet and all formulas linked with each other sheet . Create a financial statement template using the trial balance to link to the balance sheet and income statement.

Book 108 Assignment #2 The following trial balance has been prepared for Smith's Flower Service at December 31, 2017. Smith's Flower Service Trial Balance December 31, 2017 | | Accounts | eit | Credit, 100|Petty Cash 300.00 $15,796.00 107|Prepaids 2,500.00 180|Store Fixtures 7,000.00 185] Office Equipment 3,680.00 190)Computer Equipment 7,420.00 195]Leasehold Improvements 16,890.00 205)/GST Payable 4,194.00 207)GST ITC 2,189.00 210/PST Payable 3,170.00 250]Bank Loan Payable $25,000.00 301]Owner's Contributions 30,000.00 305] Owner's Withdrawals 7,000.00 401|Floral Revenue 50,000.00 405) Giftware Revenue 25,000.00 407|Delivery Revenue 1,500.00 410|PST Commission 986.00 501|Floral Purchases 30,000.00 505) Giftware Purchases 10,465.00 507|Floral Supplies 2,400.00 510}Freight In 150.00 520/Wage Expense 13,600.00 525|/CPP & El Expense 680.00 530)/WCB Expense 200.00 535|Advertising Expense 600.00 536]Automotive Expense 890.00 537|Credit Card Service Fees Expense 480.00 538]Delivery Expense 980.00 539]|Insurance Expense 1,600.00 540]|Interest & Bank Charges Expense 180.00 541||Interest on Long Term Debt 190.00 542)|Licenses, Fees & Dues Expense 100.00 543|)Meals & Entertainment Expense 150.00 544] Office Supplies Expense 90.00 545|Postage 50.00 546]Professional Fees Expense 2,000.00 547)Rent Expense 10,000.00 548]Repairs & Maintenance Expense 180.00 549)Telephone Expense 890.00 550] Utilities Expense 1,200.00 ( hrLLUM Put your name in the header of all your assignments. Don't forget, excel is a big calculator, if you are reaching for you calculator to do a calculation, use excel. Cells will contain formulas Cells are input cells Instructions: Prepare a trial balance. Prepare a balance sheet and income statement in good format. Each statement should be on a separate worksheet in your workbook. Make sure that you make it look professional. Formulas should be used wherever possible using the trial balance as a separate sheet that you can input the numbers into. Upload a copy of your workbook into Moodle in excel format. Reminder: Excel works on the BEDMAS order, brackets first, then exponents, then division and multiplication followed by addition and subtraction. Remember for future assignments. This one should be straight forward additions and subtractions. Format is important, $ signs at the start of each column of numbers and in the total. Don't forget the underlines that show when a total or subtotal is being done and then double underlines indicate that the statement is finished. Smith's Flower Service Income Statement For the Year Ended December 31, 2017 Revenue: Floral Revenue S - Giftware Revenue - Delivery Revenue - PST Commission - Net Sales: XXX Expenses: Floral Purchases - Giftware Purchases - Floral Supplies - Freight In - Wage Expense - CPP & El Expense - WCB Expense - Advertising Expense - Automotive Expense - Credit Card Service Fees Expense - Delivery Expense - Insurance Expense - Interest & Bank Charges Expense - Interest on Long Term Debt - Licenses, Fees & Dues Expense - Meals & Entertainment Expense - Office Supplies Expense - Postage - Professional Fees Expense - Rent Expense Repairs & Maintenance Expense Telephone Expense Utilities Expense Total Expenses - Net Income XXXX Cells will have formulas in them Input cells Make sure your document looks pretty (professional) - use the page space wisely - check print view if in doubt. Copy descriptions into your financials by clicking in the cell you want to copy into, hit "=" or "+", then go to the trial balance sheet and click on the cell that you want to copy from, hit enter. Continue until all formulas have been entered. This same process can be followed for copying formulas for the numbers. Smith's Flower Service Balance Sheet December 31, 2017 Current Assets Petty Cash Bank Prepaids Total Current Assets Capital Assets Store Fixtures Office Equipment Computer Equipment Leasehold Improvements Total Capital Assets TOTAL ASSETS LIABILITIES Current Liabilities GST Payable GST ITC PST Payable Long Term Liabilites Bank Loan Payable TOTAL LIABILITIES OWNER'S EQUITY Contributions Drawings Net Income Total owner's equity TOTAL LIABILITIES & EQUITY Cells will have formulas in them Input cells S - $0.00 XXX XXX XXX S \" XXX XXX S s Ss - S - XXX XXX Use negatives where a number is being subtracted (like GST ITC) to show the number in brackets. You can do this by putting a "-" sign in front of the the formula instead of "+" or "=" as noted below and then finish the formula. Watch format, this one should be a bit more centred on the page. Do not print with grid lines. This format of balance sheet is the same as what you did in the levels (that one was side by side), this one is assets on top and then the liablities and owners equity on the bottom. Skill testing question - where do we find net income to put in as a formula