Jason Jones wants to start his own business providing computer security to small businesses around Central Florida. He is an experienced IT professional who has written several software programs that offer digital protection for small networks. Jones plans to license his current software and hire programmers to develop related network security products. He has prepared a business plan with the pro forma financials in the accompanying Excel workbook Jason Jones Business Plan. He has called you to help him because his balance sheet does not balance.

ANALYZE Jasons strategic business plan as reflected in his pro forma financials by identifying the expected growth in Jasons forecast income and expense. RELATE this growth to the capital he expects to invest. EXPLAIN what he needs to do to get his balance sheet to balance. IDENTIFY any other problems you see with his financials.

Numbers File Edit Insert Table Organize Format Arrange View Share Window Help * 50% O Thu 5:35 PM QE chegg.com R Jones Business Plan 125% Zoom 20 Collaborate View Add Category Insert Table Chart Text Shape Media Comment Format Organize + Income Statement Balance Sheet Sheet Sheet Name Income Statement Y1 Y2 Y3 Y4 Y5 Background $152,500 376,875 529,375 15,250 514,125 $150,000 1,500,000 1,650,000 15,000 1,635,000 $200,000 2,550,000 2,750,000 20,000 2,730,000 $250,000 3,900,000 4,150,000 25,000 4,125,000 $250,000 5,400,000 5,650,000 25,000 5,625,000 Duplicate Sheet Delete Sheet Revenues Software Licenses Maintenance Fees Total Sales Cost of Goods Sold Gross Profit Operating Expenses Network Access Fees Software Development Salaries Selling Expense Office Expense Other Total SG & A Expense Operating Profit Other Expenses Interest Income Earnings Before Taxes Income Taxes Extraord. Item: Tax Refund or Carryforward Net Income 120,000 204,000 582,000 120,000 62,400 12.000 1,100,400 -586,275 24,000 12,000 611,100 120,000 62,400 12,000 841,500 793,500 24,000 12,000 641,655 126,000 65,520 12,600 881,775 1,848,225 24,000 12,000 673,738 132,300 68,796 13,230 924,064 3,200,936 24,000 12,000 707,425 138,915 72,236 13,892 968,468 4,656,532 0 -586,275 2,393 2,393 $586,275) 0 795,481 238,644 201,071 $757.908 3,213 1,878,438 563,531 0 $1,314.907 2,928 3,280,164 984,049 0 $2,296,115 6.624 4,824,157 1,447,247 0 $3.376,910 5 tv Numbers File Edit Insert Table Organize Format Arrange View Share Window Help * E 50% D Thu 5:35 PM QE chegg.com Jones Business Plan R + 1 125% Zoom lo Collaborate e Format Organize View Add Category Insert Table Chart Text Shape Media Comment + Income Statement Balance Sheet Sheet Sheet Name Balance Sheet YO Y1 Y2 Y3 Y4 Y5 Background $25,000 0 0 25,000 $25,000 0 151,252 176,252 $25,000 24,000 845,395 894,395 $25,000 25,000 2,065,630 2,115,630 $25,000 30,000 4,192,986 4,247,986 $25,000 35,000 Z.323,688 7,383,688 Current Assets Cash Marketable Securities Accounts Receivable Total Current Assets Long-term Assets Computer Hardware Total Assets Liabilities and Owners' Equity Accounts Payable Total Current Liabilities Duplicate Sheet 750,000 $775,000 750,000 $926,252 750,000 $1,644,395 800,000 $2,915,630 800,000 $5,047.986 800,000 $8,183,688 Delete Sheet 250 250 750 750 750 750 1,000 1,000 1,250 1,250 1.250 1,250 Total Liabilities 250 750 750 1,000 1,250 1,250 Retained Earnings Shareholder Equity Total Liabilities and Equity 0 750,000 $750.250 -574,488 750,000 $176.262 183,420 750,000 $934. 170 1,498,326 750,000 $2,249,326 3,794,441 750,000 $4,545,691 7,171,351 750,000 $7.922.601 5 tv Numbers File Edit Insert Table Organize Format Arrange View Share Window Help * 50% O Thu 5:35 PM QE chegg.com R Jones Business Plan 125% Zoom 20 Collaborate View Add Category Insert Table Chart Text Shape Media Comment Format Organize + Income Statement Balance Sheet Sheet Sheet Name Income Statement Y1 Y2 Y3 Y4 Y5 Background $152,500 376,875 529,375 15,250 514,125 $150,000 1,500,000 1,650,000 15,000 1,635,000 $200,000 2,550,000 2,750,000 20,000 2,730,000 $250,000 3,900,000 4,150,000 25,000 4,125,000 $250,000 5,400,000 5,650,000 25,000 5,625,000 Duplicate Sheet Delete Sheet Revenues Software Licenses Maintenance Fees Total Sales Cost of Goods Sold Gross Profit Operating Expenses Network Access Fees Software Development Salaries Selling Expense Office Expense Other Total SG & A Expense Operating Profit Other Expenses Interest Income Earnings Before Taxes Income Taxes Extraord. Item: Tax Refund or Carryforward Net Income 120,000 204,000 582,000 120,000 62,400 12.000 1,100,400 -586,275 24,000 12,000 611,100 120,000 62,400 12,000 841,500 793,500 24,000 12,000 641,655 126,000 65,520 12,600 881,775 1,848,225 24,000 12,000 673,738 132,300 68,796 13,230 924,064 3,200,936 24,000 12,000 707,425 138,915 72,236 13,892 968,468 4,656,532 0 -586,275 2,393 2,393 $586,275) 0 795,481 238,644 201,071 $757.908 3,213 1,878,438 563,531 0 $1,314.907 2,928 3,280,164 984,049 0 $2,296,115 6.624 4,824,157 1,447,247 0 $3.376,910 5 tv Numbers File Edit Insert Table Organize Format Arrange View Share Window Help * E 50% D Thu 5:35 PM QE chegg.com Jones Business Plan R + 1 125% Zoom lo Collaborate e Format Organize View Add Category Insert Table Chart Text Shape Media Comment + Income Statement Balance Sheet Sheet Sheet Name Balance Sheet YO Y1 Y2 Y3 Y4 Y5 Background $25,000 0 0 25,000 $25,000 0 151,252 176,252 $25,000 24,000 845,395 894,395 $25,000 25,000 2,065,630 2,115,630 $25,000 30,000 4,192,986 4,247,986 $25,000 35,000 Z.323,688 7,383,688 Current Assets Cash Marketable Securities Accounts Receivable Total Current Assets Long-term Assets Computer Hardware Total Assets Liabilities and Owners' Equity Accounts Payable Total Current Liabilities Duplicate Sheet 750,000 $775,000 750,000 $926,252 750,000 $1,644,395 800,000 $2,915,630 800,000 $5,047.986 800,000 $8,183,688 Delete Sheet 250 250 750 750 750 750 1,000 1,000 1,250 1,250 1.250 1,250 Total Liabilities 250 750 750 1,000 1,250 1,250 Retained Earnings Shareholder Equity Total Liabilities and Equity 0 750,000 $750.250 -574,488 750,000 $176.262 183,420 750,000 $934. 170 1,498,326 750,000 $2,249,326 3,794,441 750,000 $4,545,691 7,171,351 750,000 $7.922.601 5 tv