I have to do a five year pro forma income statement and balance sheet. I am having difficulty in this area. I have done an Income statement but am worried it is not correct also the balance sheet is off as well. Can you help in this?

XYZ Company Pro Forma Income Statement for Year Ending 2014 -2019 YEAR Current YEAR 1 YEAR 2 YEAR 3 YEAR 4 YEAR 5 Projected Growth each year = 13% 1. Gross Sales 2. Less: Cash Discounts A. NET SALES Cost of Sales: 3. Beginning Inventory 4. Plus: Net Purchases 10% increase per year 5. Plus: Production Labor 3% yr 1 and 6% after 6. Less: Ending Inventory B. COST OF GOODS SOLD C. GROSS PROFIT Selling Expenses 7. Wages Increased at 2% each year 8. Commissions 9. Marketing D. TOTAL SELLING EXPENSES Fixed Expenses 10. Salaries Increased at 5% each year 11. Payroll Taxes 12. Benefits 12% increase in cost 13. Office Supplies 14. Postage 15. Professional Fees 16. Telephone 17. Utilities 18. Training and Education 19. Miscellaneous 1,750,450 2,752 $1,747,698 1,978,009 3,110 100% 50,000 610,162 420,108 30,000 $1,974,899 2,235,150 3,514 100% 30,000 671,178 432,711 30,000 $2,231,636 2,525,719 3,971 100% 30,000 738,296 472,033 60,000 $2,521,748 2,854,063 4,487 100% 60,000 812,126 500,355 60,000 $2,849,575 3,225,091 5,070 100% 60,000 893,338 530,377 50,000 $3,220,020 100% 50,000 982,672 562,199 40,000 $1,050,270 60.1% $1,103,889 55.9% $1,240,329 55.6% $1,312,481 52.0% $1,433,715 50.3% $1,554,871 48.3% $697,428 39.9% $871,009 44.1% $991,306 44.4% $1,209,267 48.0% $1,415,861 49.7% $1,665,149 51.7% 75,000 25,000 25,000 $125,000 76,500 27,500 25,000 7.2% 225,000 29,000 27,000 500 250 2,000 850 950 250 50 $129,000 78,030 30,000 25,000 6.5% 236,250 29,000 30,240 500 250 2,000 850 950 250 50 $133,030 79,591 32,500 35,000 6.0% 248,063 29,000 33,869 550 300 2,050 850 950 260 50 $147,091 81,182 37,500 35,000 5.8% 260,466 29,000 37,933 550 300 2,050 850 950 260 50 $153,682 82,806 40,000 30,000 5.4% 273,489 29,000 42,485 550 300 2,000 850 950 260 50 $152,806 4.7% 287,163 29,000 47,583 550 250 2,000 850 950 250 50 E. TOTAL OPERATING EXPENSES $285,850 16.4% $300,340 15.2% $315,941 14.2% $332,409 13.2% $349,934 12.3% $368,647 11.4% F. OPERATING PROFIT $286,578 16.4% $441,669 22.4% $542,335 24.3% $729,768 28.9% $912,244 32.0% $1,143,696 35.5% Other Income (Expense) Interest Depreciation Amortization ($9,650) ($12,000) ($2,500) G. TOTAL OTHER INCOME (EXPENSE) ($24,150) H. TOTAL PRE-TAX PROFIT $262,428 Income Tax Allowance $118,093 G. NET OPERATING PROFIT (LOSS) $144,335 ($9,650) ($12,000) ($2,500) ($9,650) ($12,000) ($2,500) ($24,150) 15.0% $417,519 ($24,150) 21.1% $118,093 8.3% $299,426 ($9,650) ($12,000) ($2,500) $518,185 ($24,150) 23.2% $118,093 15.2% $400,092 ($9,650) ($20,000) ($2,500) $705,618 ($32,150) 28.0% $118,093 17.9% $587,525 ($9,650) ($20,000) ($2,500) $880,094 ($32,150) 30.9% $118,093 23.3% $762,001 $1,111,546 34.5% $118,093 26.7% $993,453 30.9% XYZ Company Balance Sheet for year ended December 31, 2014 2014 2015 2016 2017 2018 2019 $10,525 $27,000 $30,000 $2,000 $69,525 $11,893 $30,510 $30,000 $2,000 $74,403 $13,439 $34,476 $30,000 $2,000 $79,916 $15,186 $38,958 $60,000 $2,000 $116,145 $17,161 $44,023 $60,000 $2,000 $123,184 $19,392 $49,746 $50,000 $2,000 $121,137 $215,000 $80,000 $5,000 $300,000 $203,000 $80,000 $5,000 $288,000 $191,000 $80,000 $5,000 $276,000 $179,000 $80,000 $5,000 $264,000 $167,000 $80,000 $5,000 $252,000 $155,000 $80,000 $5,000 $240,000 $369,525 $362,403 $355,916 $380,145 $375,184 $361,137 $20,000.00 $5,000 $15,000 $20,000 $5,000 $20,000 $5,000 $15,000 $20,000 $5,000 $15,000 $20,000 $5,000 $15,000 $20,000 $5,000 $15,000 $40,000 $25,000 $40,000 $40,000 $40,000 $40,000 Long-term debt and capital leases Loans payable to stockholders Total Long-term Liabilities $45,500 $60,500 $106,000 $45,500 $52,635 $98,135 $45,500 $45,792 $91,292 $45,500 $39,839 $85,339 $45,500 $34,660 $80,160 $45,500 $30,154 $75,654 Total Liabilities $146,000 $123,135 $131,292 $125,339 $120,160 $115,654 $1,000 $25,000 $53,190 $144,335 $223,525 $1,000 $25,000 $53,190 $144,335 $223,525 $1,000 $25,000 $53,190 $144,335 $223,525 $1,000 $25,000 $53,190 $144,335 $223,525 $1,000 $25,000 $53,190 $144,335 $223,525 $1,000 $25,000 $53,190 $144,335 $223,525 $369,525 $346,660 $354,817 $348,864 $343,685 $339,179 Current Assets Cash Accounts Receivable Inventory Prepaid Expenses Total Current Assets Fixed Assets Property - net of depreciation Equipmnet - net of depreciation Vehicles - net of depreciation Total Fixed Assets TOTAL ASSETS LIABILITIES & EQUITY Current Liabilities Revolving lines of credit Accounts Payable Current Portion of Long-term Debt Total Current Liabilities Long-Term Liabilities Stockholders Equity Common Stock Additional Paid-in Capital Retained Earning (Cum from prior years) Retained Earnings (From Current P&L) Total Stockholders Equity TOTAL LIABILITIES & EQUITY