Can I please get someone to help with the (Horizontal + Vertical Analysis) of the attached document.

Thank you

Financial Statement Information Group4OLsection342016 Accounts payable Accounts receivable Amortization expense Cash Common stock Net Sales Notes payable Prepaid expenses Office Equipment Salaries & Commissions Office overhead expenses Supplies Subcontract fees Professional Fees Advertising Misc. Expense Direct Wages and Expenses Common Stock Dividends Accrued Liabilities Accumulated Amortization Income Tax Expense Opening Retained Earnings 2014 ect data'!b Other Information that may be useful for ratio analysis $ $ $ $ $ $ $ $ 2015 6,556 176,927 38,000 194,928 100,000 1,125,000 17,000 14,000 $ $ $ $ $ $ $ $ $ $ $ $ $ 255,500 216,000 7,893 22,500 21,091 9,111 27,060 26,871 450,000 50,000 8,667 159,000 76,619 $ $ $ $ $ $ $ $ 2014 6,556 87,000 38,000 105,000 100,000 870,000 55,000 14,000 $ $ $ $ $ $ $ $ $ $ $ $ $ $ 255,500 180,000 7,893 17,400 19,877 9,111 27,060 26,871 348,000 20,000 8,667 121,000 48,947 43,436 Other Info # of Common Stock 2015 250000 shares Market share price $ 2.90 per share Opening Accounts Receivable Income tax rate 2014 250000 shares 2.25 per share Industry ratios have been provided on ratio tab 76,000 25% 25% Other Information that may be useful for 2016 budgeting purposes General: Sales: Assume for budgeting purposes that the loan was approved your group took over the business January 1, 2016. Average revenue per placement is expected to stay the same for 2016 at $15,000 per placement. However the number of placements are expected to increase by 15% in 2016. The strongest months are September and March where 15% of the annual business is done each of those months. The slowest months are June, July and December where 4% of the annual business is done in each of those months. The rest of the business is spread out evenly over the rest of the months. Collections: Sales are all sold on account. 50% of sales are collected in the month after the sale, 25% in the second month after the sale and 25% in the 3rd month after the sale. Assume all sales are collected (no bad debts). For closing 2015 accounts receivable assume 50% will be collected in January and 50% in February. Direct Wages: Direct wages in 2016 are expected to continue to be 40% of sales. LFPA pays their employees semi-monthly such that 50% of the wages are paid in the month they are earned and 50% are paid in the month following the month in which they are earned. Other Expenses: The cost behaviour for all other expenses are expected to remain the same for 2016 as they were for 2015 and 2014. Note that some of these expenses are fixed in nature, some are variable and some are mixed. In addition assume that these expenses are paid in the month they are incurred. Fixed expenses should be allocated evenly over the 12 months, variable expenses will vary each month based on sales. Mixed expenses need to be separated into their fixed and variable components and then allocated accordingly. Dividends: Your group, once the purchase has been completed, expects to pay out dividends of $15,000 to each owner (5 group members=5 owners, 4 group members=4 owners). Dividends will be paid out in December 2016. Financing: For the purpose of the budget assume the interest rate negotiated on the $500,000 loan is 5% and is payable monthly. In addition there are no payments to pay down the loan in 2016. Loan principal payments are to start in 2017 at an amount of $8,500 per month. Assume that the note payable of $68,000 is paid off using money received from the loan (so no interest expense related to the note payable) Equipment: In September of 2016 LFPA is expecting to replace its computer equipment in the office. The expected cost is $75000. Assume it will be paid in cash when purchased. #REF! #N/A Group4OLsection342016 Leap Forward Placement Agency Income Statement For the Year Ended December 31st 2015 2014 2016 (projected) Revenues Revenues Net Sales Total Revenues $ 1,125,000 $ 870,000 $ 1,125,000 $ 870,000 $ 1,293,750 $ 1,293,750 Expenses Supplies Direct Wages & Expenses Salaries & Commissions Office Overhead Expense Amortization Expense Advertising Subcontract Fees Profesional Fees Misc. Expense Income Tax Expenses Total Expenses $22,500 $17,400 $450,000 $348,000 $216,000 $180,000 $7,893 $7,893 $38,000 $38,000 $27,060 $27,060 $21,091 $19,877 $9,111 $9,111 $26,871 $26,871 $76,619 $48,947 $ 895,145 $ 723,159 $ 25,875 $517,500 $239,066 $ 7,893 $ 38,000 $ 27,060 $ 25,875 $ 9,111 $ 26,871 $ 80,625 $ 997,876 Net Income $ 229,855 $ 295,874 $ 146,841 Group4OLsection342016 Leap Forward Placement Agency Statement of Retained Earnings For the Year Ended December 31st Retained Earnings Add: Net Income Subtract Dividends Retained Earnings, Ending December 31 2015 2014 $148,384 $43,436 $229,855 $146,841 $50,000 $20,000 $ 350,132 $ 170,277 Leap Forward Placement Agency Balance Sheet As At December 31st 2015 Assets: Current Assets: Cash Accounts Recievable Prepaid Expense Total Current Assets: 2014 $ 194,928 $ 105,000 $176,927 $87,000 $14,000 $14,000 $385,855 $206,000 Long Term Assets: Office Equipment Less: Accumulated Amortization Total Assets 255,500 $255,500.00 -$159,000 -$121,000 $ 482,355 $ 340,500 Liabilities: Accounts Payable Notes Payable Accrued Liabilities Total Liabilities $ 6,556 $ 6,556 $17,000 $55,000 $8,667 $8,667 $32,223 $70,223 Sharholders' Equity Common Stock Retained Earnings Total Shareholders' Equity Total Liabilites & Shareholders' Equity 100,000 100,000 350,132 170,277 450,132 270,277 $ 482,355 $ 340,500 updated March 11, 2016 by Rebecca $ Group4OLsection342016 2015 2014 Industry Current Ratio 1.90 Quick Ratio 1.70 Gross Margin 37.9% Return on Shareholders Equity 27% Receivable Turnover 5.89 Average Collection Period 62.0 Earnings Per Share $1.25 Dividend Yield 4.0% P/E Ratio 6.20 Debt to Equity Ratio 1.30 Return on Assets 12.3% 24+#REF!)/sn Group4OLsection342016 Leap Forward Placement Agency Breakeven and Target Profit Calculations 2016 projected Variable expenses per placement Fixed Expenses in total Annual Breakeven in placements sold Annual Breakeven in $ # of Placements for target profit of $ 200,000 # of Placements for target profit of $ 400,000 # of Placements for target proift of $ 600,000 10% increase in sales for 2017 will mean what increase in 2017 net income ### Month % sold each month ==> Opening Cash Balance Inflows Total Sales Collections Current month Collections First month Collections Second month Accounts Recevable Loan Total Inflows Outflows Payment current payment 1st month Loan Interest Office Overhead Supplies Advertising Professional Fees Subcontract Fees Misc Salaries & Commission Taxes Dividends Equipment Notes Payable Accrued Liabilities Total Outflows Net Cash Flow Cash Balance January February March April May Leap Forward Placement Agency June July August Sept Oct Nov Dec 8% 8% 16% 8% 8% 4% 4% 8% 16% 8% 8% 4% $ 194,928 $ 698,768$759,325 $719,973 $774,867 $824,586 $ 892,966 $ 919,946 $ 915,327 $ 800,974 $ 842,930 $ 892,649 103,500 ### 207,000 51,750 51,750 25,875 103,500 103,500 25,875 25,875 103,500 51,750 51,750 25,875 51,750 51,750 25,875 51,750 51,750 25,875 25,875 25,875 103,500 ### 12,937 ### 207,000 51,750 12,937 12,937 103,500 103,500 25,875 12,937 103,500 51,750 51,750 25,875 88,463 500,000 588,463 ### ### 77,625 155,250 129,375 129,375 77,625 64,687 77,624 142,312 129,375 20,700 ### 20,700 ### ### ### ### ### ### ### ### ### 41,400 20,700 2,083 658 4,140 2,255 759 2,156 2,239 33,867 6,719 20,700 41,400 2,083 658 2,070 2,255 759 2,156 2,239 19,316 6,719 20,700 20,700 2,083 658 2,070 2,255 759 2,156 2,239 19,316 6,719 10,350 20,700 2,083 658 1,035 2,255 759 2,156 2,239 12,040 6,719 10,350 10,350 2,083 658 1,035 2,255 759 2,156 2,239 12,040 6,719 20,700 ### ### ### 2,070 ### ### ### ### 19,316 ### 41,400 20,700 2,083 658 4,140 2,255 759 2,156 2,239 33,867 6,719 20,700 41,400 2,083 658 2,070 2,255 759 2,156 2,239 19,316 6,719 20,700 20,700 2,083 658 2,070 2,255 759 2,156 2,239 19,316 6,719 2,083 658 2,070 2,255 759 2,156 2,239 19,316 6,719 17,000 8,667 84,623 503,840 $ 698,768 Total 100% 51,750 51,750 25,875 51,750 $ 1,293,750 $ 621,000 $ 284,624 $ 258,749 $ 176,926 $ 500,000 129,375 1,841,299 10,350 20,700 2,083 658 1,035 2,255 759 2,156 2,239 12,040 6,719 75,000 $ 258,750 $ 248,400 $ 25,000 $ 7,894 $ 25,875 $ 27,060 $ 9,111 $ 25,875 $ 26,871 $ 239,066 $ 80,625 $ 75,000 75,000 $ 75,000 $ 17,000 $ 8,667 79,656 116,977 100,356 79,656 60,995 50,645 69,306 191,977 100,356 79,656 135,995 $ 1,150,194 60,557 - 39,352 54,894 49,719 68,380 26,980 4,619 $ (114,353) 41,956 49,719 6,620 $ 759,325$719,973 $774,867 $824,586 $892,966 $ 919,946 $ 915,327 $ 800,974 $ 842,930 $892,649 $ 886,029 $ 886,029