Please Help...I am really confused

Mini-Project 2- Saved to my Mac AutoSave $ u- Home Insert Draw Page Layout Calibri (Body) 11 Peste 3 BIU R Formulas A A A Data = E Review = = View = Q- Search Sheet Share Comments Ey O 4 Sort! Find & Incas General 2 Wraa Text Nerge & Center - Conditional Format - $ % -% Insert call Styles Delete Format Y Formalingas Table l e Select B28 x fx CAPTAIN JET INC. BALANCE SHEET 15,438 (50) CAPTAIN JETINC. INCOME STATEMENT FOR THE YEAR ENDED DECEMBER 31, 2014 31-Dec-13 15,388 4,723 3,150 6,650 10,655 10,600 7,088 5,052 19,031 3.000 CAPTAIN JET INC. INCOME STATEMENT 3 FOR THE YEAR ENDED DECEMBER 31, 2014 4 Sales Revenue 5 Sales Return 6 Net Sales 7 Cost of Goods sold Gross Pralit 9 Utilities Expenses 10 Salary and Wages per ses 11 Rent Expenses 12 Depreciation Expenses 13 Inter Expono 14 Supplies Expenses 15 By Debt Expenses 16 Total Operating Exames 17 Earnings before income Taxes 18 Income Tax Expenses 19 Earning after Income Taxes 1,519 5.689 Retained Earnines, Beginnir Net Incomci' Loss Dividends Payment Retained Earnings, End of th 11001 19,264 500 23,337 1,781 17.130 785 163 31-Dec-14 Current Assets Cash Accounts Receivable Inventaries Prepaid insurance I Prepaid Rent Total Current Assets Non-Current Assets Long term investments Investments in equily securities Land hold for future development Property, Plant, and Equipment Buildings LissAccumulated Depreciation Intangible Assets Capitalized Development Costs Goodwill Other Icentifiable intable ASOS Total Non-Current Assets Total Assets 6,375 5,608 6.375 5,588 48.875 125.219) 47,000 123,4381 1.030 9,500 6,000 52,219 25,526 1.000 9,500 6,000 52.125 69,255 6,638 4,188 188 1,500 1,086 1,500 1,055 156 10,658 7,755 Current Liabilities Accounts peyable Salary and Wages Payable Interest Payable Uneare Revenue Income Tax payahle Property taxes payable Utilities payable Total Current Liabilities Non-Current Uabilities Notes payable Provisions Related ta Pensions Bonds Payable Total Non-Current Liabilities Tatal Liabilities Stockholders' Equity Common Stuck $10 pur, 11,000 und 10.000 shares) nwood CakeWdhddons can use to 15,000 13,750 15,000 25,658 13,750 21,505 13,750 12,500 loan FS's Ratios Projected FS + Select destination and press ENTER or choose Paste # E - + 100% Mini-Project 2- Saved to my Mac AutoSave $ u- Home Insert Draw Page Layout Calibri (Body) 11 Peste BIV A B28 x fx Formulas A A Data = E Review = = View = Q- Search Sheet Share Comments Ey O 4 X General 2 Wraa Text E Merge & Center - Conditional Format - S % call Styles Insert Delctc Forma: Tocas Formalingas Table Sort Filter Fird & Select 15,000 25,658 13,750 21,505 12,500 12.500 Total Non-Current Liabilities Total Liabilities Stockholders' Equity Cominon Stock$10 par, 11,000 and 10.000 shares) Preferred Stack 5% dividend, $100 a values, 1050 and 1000 Pald-in capital Common Stock Paid-in-capital - Preferred Stock Retalne Farnings Accumulated Other Comprchensive Income Less: Treasury Stock Total Stockholders' Equity Total abilities and texkholders Equity 13,750 13,125 3,439 1,250 19,254 1,250 19,031 11,594) 49,858 75,526 (1,594) 47.750 69.255 FS's Ratios Projected FS + Select destination and press ENTER or choose Paste # 2 - + 100% Mini-Project 2- Saved to my Mac View AutoSave $ u- Home Insert Draw Page Layout Formulas Calibri (Body) 11 A A Peste 3 BIU B O YA D9 x fx Data = = Review = = Q- Search Sheet Share Comments Ey O 4 X Filter Select = 2 Wraa Text Werge & Center - - General $ - % ** Formalingas Table Styles Calculate the following ratios for year 2014 (round all ratios to two places behind the decimall: 1 Working capital 12.539 2 Orrent ratia 3 Acid test ratio 4 Accounts recchable turnover luse net salsas numerator) 11 5 Collection period of receivables fuse 360 days in each year 13 14 15 16 17 6 Accounts payablaturaver ratia 7 Inventory turnover ratio 19 Days to sell inventory 9 Debt to Equity ratio 10 Times interest earned 11 RNOM laxume 12% tax ratel 26 12 ROCE 22 34 32 FS's Ratios Projected FS + Select destination and press ENTER or choose Paste # - 0 + 100% Mini-Project 2- Saved to my Mac View AutoSave $ u- Home Insert Draw Page Layout Formulas Calibri (Body) 11 A A Peste B IV. B C G32 x vfx Data = Review = = Q- Search Sheet Share Comments Ey O 4 2 Wraa Text E Merge & Center General $ % - - E ) * Formalingas Table Styles X Filter Select 1 Provide projected Income Statement, Retained Earnings statement and Projected Balance Sheet on the right 2 using the following assumptions 10 1 sale growth is 110%; salesrecum, as a percentage of sales revenue, cos not change 2 Grass profit margin is the sames 2014 profit margin 3 Depreciation cipars/Prior PPE Igrass) -4% 4 Interest expense, Prior year lonr-term debt = 6% 5 All other expenses linsurance, supplies, utilities, bad deal and rent grow at thes 6 Income tax mpcnsc pre tax Income-12% 7 AVR turnover is the same as that calculated for year 2014 8 AVP turnover is the same as the calculated for year 2014 9 Inventoryturnover isthe same as the calculated for year 2014 10 There is no change in current assets other than Cash, Ak and inventory 11 Capitalspenditure/Sales -7% 12 Assume na changain long terms mcept for PPLE. 13 Aegume na change in all liabilities, excpet for A/P 14 Assurreno change in shareholders' Equity except for Retained Earnings 15 No dividend is paid on common stack and SX didendis paldon preterred stock CAPTAINJETINC. INCOME STATEMENT FOR THE YEAR ENDED DECEMBER 31, 2014 Sales Revenue Lex Sales Return stca 2 Net Sales Cast of Good Sald set Gross Profit stca 3 utilities Expenses Salary and Wages Expenses Rent Expenses stcas Depreciation Expens Interest Expenses Supplies Expenses stcas Bac Debt Expenses Total operating Expenses Earning:before income Taxes Income Tax Lupenses Earnings after Income Taxes 13 14 15 16 17 19 CAPTAIN JET INC. INCOME STATEMENT FOR THE YEAR ENDED DECEMBER 31, 2014 Recained Earrings Beginning of the year Not Income Lass Dividends Payment Recained Earrings End of the year CAPTAIN JET INC. Bwance Sheet FOR THE YEAR ENDED DECEMBER 31, 2014 Current Assets 34 Sep Use calculated A/R tumover from 'ratios Use calculated inventory turnover from 'ratios 32 Accounts Receivable Inventories Prepaid Insurance Prepaid Rent Total Current Assets Non-Current Assets Long term investments Investments in equity Securitie Landheld for future develoom FS's Ratios Projected FS Select destination and press ENTER or choose Paste # E 2 - + 100% Mini-Project 2- Saved to my Mac AutoSave $ u- Home Insert Draw Page Layout Calibri (Body) 11 Pezie* BLU E G32 x v fx Formulas A A Data = Review = = Ez View = Q- Search Sheet Share Comments Ey O 4 . Sort Find & Treas X Filter Select 2 Wraa Text Merge & Center - - General $ -% Insert Delcte Format Formalingas Table Styles steun Non-Current Assets Long-term Investments Investments in equity Securitic Landheld for future cevelopm Property, Plant, and Equipment Buildings Less: Accumulate Depreciatic Intargil AS Capitalized Development Cost Goudwill Other dans la lintang A Total Non Current Assets Total Assets steps step 6 step 7 steu sten 7 Use calculated A/P turnover from ratios steus stea steus stea step 9 stev 10 Current Liabilities Accounts payable Salary and Wapas Payable nterest Payable Uneaed Revenue income Tax payable Property taxes payable Utilities payable Total Current Liabilities Non Current Liabilities Notes peyable Pravidians Rated to Pandans Bands Payable Total Non-Current Liabilities Total Liabilities Stockholders' Equity Common Stock Preferred SockSX dividendi Pald-in capital Comman Stock Paid-in-capital-Preferred Stuck Recained Farrings Accumulated Other Comprehens Less Treasury Stock Total Stockholders' Equity Total Liabilities and Stockholders' Equity sten 12 Stan 12 sen 12 Ste 11 FS's Ratios Projected FS Select destination and press ENTER or choose Paste # E 2 - + 100% Mini-Project 2- Saved to my Mac AutoSave $ u- Home Insert Draw Page Layout Calibri (Body) 11 Peste 3 BIU R Formulas A A A Data = E Review = = View = Q- Search Sheet Share Comments Ey O 4 Sort! Find & Incas General 2 Wraa Text Nerge & Center - Conditional Format - $ % -% Insert call Styles Delete Format Y Formalingas Table l e Select B28 x fx CAPTAIN JET INC. BALANCE SHEET 15,438 (50) CAPTAIN JETINC. INCOME STATEMENT FOR THE YEAR ENDED DECEMBER 31, 2014 31-Dec-13 15,388 4,723 3,150 6,650 10,655 10,600 7,088 5,052 19,031 3.000 CAPTAIN JET INC. INCOME STATEMENT 3 FOR THE YEAR ENDED DECEMBER 31, 2014 4 Sales Revenue 5 Sales Return 6 Net Sales 7 Cost of Goods sold Gross Pralit 9 Utilities Expenses 10 Salary and Wages per ses 11 Rent Expenses 12 Depreciation Expenses 13 Inter Expono 14 Supplies Expenses 15 By Debt Expenses 16 Total Operating Exames 17 Earnings before income Taxes 18 Income Tax Expenses 19 Earning after Income Taxes 1,519 5.689 Retained Earnines, Beginnir Net Incomci' Loss Dividends Payment Retained Earnings, End of th 11001 19,264 500 23,337 1,781 17.130 785 163 31-Dec-14 Current Assets Cash Accounts Receivable Inventaries Prepaid insurance I Prepaid Rent Total Current Assets Non-Current Assets Long term investments Investments in equily securities Land hold for future development Property, Plant, and Equipment Buildings LissAccumulated Depreciation Intangible Assets Capitalized Development Costs Goodwill Other Icentifiable intable ASOS Total Non-Current Assets Total Assets 6,375 5,608 6.375 5,588 48.875 125.219) 47,000 123,4381 1.030 9,500 6,000 52,219 25,526 1.000 9,500 6,000 52.125 69,255 6,638 4,188 188 1,500 1,086 1,500 1,055 156 10,658 7,755 Current Liabilities Accounts peyable Salary and Wages Payable Interest Payable Uneare Revenue Income Tax payahle Property taxes payable Utilities payable Total Current Liabilities Non-Current Uabilities Notes payable Provisions Related ta Pensions Bonds Payable Total Non-Current Liabilities Tatal Liabilities Stockholders' Equity Common Stuck $10 pur, 11,000 und 10.000 shares) nwood CakeWdhddons can use to 15,000 13,750 15,000 25,658 13,750 21,505 13,750 12,500 loan FS's Ratios Projected FS + Select destination and press ENTER or choose Paste # E - + 100% Mini-Project 2- Saved to my Mac AutoSave $ u- Home Insert Draw Page Layout Calibri (Body) 11 Peste BIV A B28 x fx Formulas A A Data = E Review = = View = Q- Search Sheet Share Comments Ey O 4 X General 2 Wraa Text E Merge & Center - Conditional Format - S % call Styles Insert Delctc Forma: Tocas Formalingas Table Sort Filter Fird & Select 15,000 25,658 13,750 21,505 12,500 12.500 Total Non-Current Liabilities Total Liabilities Stockholders' Equity Cominon Stock$10 par, 11,000 and 10.000 shares) Preferred Stack 5% dividend, $100 a values, 1050 and 1000 Pald-in capital Common Stock Paid-in-capital - Preferred Stock Retalne Farnings Accumulated Other Comprchensive Income Less: Treasury Stock Total Stockholders' Equity Total abilities and texkholders Equity 13,750 13,125 3,439 1,250 19,254 1,250 19,031 11,594) 49,858 75,526 (1,594) 47.750 69.255 FS's Ratios Projected FS + Select destination and press ENTER or choose Paste # 2 - + 100% Mini-Project 2- Saved to my Mac View AutoSave $ u- Home Insert Draw Page Layout Formulas Calibri (Body) 11 A A Peste 3 BIU B O YA D9 x fx Data = = Review = = Q- Search Sheet Share Comments Ey O 4 X Filter Select = 2 Wraa Text Werge & Center - - General $ - % ** Formalingas Table Styles Calculate the following ratios for year 2014 (round all ratios to two places behind the decimall: 1 Working capital 12.539 2 Orrent ratia 3 Acid test ratio 4 Accounts recchable turnover luse net salsas numerator) 11 5 Collection period of receivables fuse 360 days in each year 13 14 15 16 17 6 Accounts payablaturaver ratia 7 Inventory turnover ratio 19 Days to sell inventory 9 Debt to Equity ratio 10 Times interest earned 11 RNOM laxume 12% tax ratel 26 12 ROCE 22 34 32 FS's Ratios Projected FS + Select destination and press ENTER or choose Paste # - 0 + 100% Mini-Project 2- Saved to my Mac View AutoSave $ u- Home Insert Draw Page Layout Formulas Calibri (Body) 11 A A Peste B IV. B C G32 x vfx Data = Review = = Q- Search Sheet Share Comments Ey O 4 2 Wraa Text E Merge & Center General $ % - - E ) * Formalingas Table Styles X Filter Select 1 Provide projected Income Statement, Retained Earnings statement and Projected Balance Sheet on the right 2 using the following assumptions 10 1 sale growth is 110%; salesrecum, as a percentage of sales revenue, cos not change 2 Grass profit margin is the sames 2014 profit margin 3 Depreciation cipars/Prior PPE Igrass) -4% 4 Interest expense, Prior year lonr-term debt = 6% 5 All other expenses linsurance, supplies, utilities, bad deal and rent grow at thes 6 Income tax mpcnsc pre tax Income-12% 7 AVR turnover is the same as that calculated for year 2014 8 AVP turnover is the same as the calculated for year 2014 9 Inventoryturnover isthe same as the calculated for year 2014 10 There is no change in current assets other than Cash, Ak and inventory 11 Capitalspenditure/Sales -7% 12 Assume na changain long terms mcept for PPLE. 13 Aegume na change in all liabilities, excpet for A/P 14 Assurreno change in shareholders' Equity except for Retained Earnings 15 No dividend is paid on common stack and SX didendis paldon preterred stock CAPTAINJETINC. INCOME STATEMENT FOR THE YEAR ENDED DECEMBER 31, 2014 Sales Revenue Lex Sales Return stca 2 Net Sales Cast of Good Sald set Gross Profit stca 3 utilities Expenses Salary and Wages Expenses Rent Expenses stcas Depreciation Expens Interest Expenses Supplies Expenses stcas Bac Debt Expenses Total operating Expenses Earning:before income Taxes Income Tax Lupenses Earnings after Income Taxes 13 14 15 16 17 19 CAPTAIN JET INC. INCOME STATEMENT FOR THE YEAR ENDED DECEMBER 31, 2014 Recained Earrings Beginning of the year Not Income Lass Dividends Payment Recained Earrings End of the year CAPTAIN JET INC. Bwance Sheet FOR THE YEAR ENDED DECEMBER 31, 2014 Current Assets 34 Sep Use calculated A/R tumover from 'ratios Use calculated inventory turnover from 'ratios 32 Accounts Receivable Inventories Prepaid Insurance Prepaid Rent Total Current Assets Non-Current Assets Long term investments Investments in equity Securitie Landheld for future develoom FS's Ratios Projected FS Select destination and press ENTER or choose Paste # E 2 - + 100% Mini-Project 2- Saved to my Mac AutoSave $ u- Home Insert Draw Page Layout Calibri (Body) 11 Pezie* BLU E G32 x v fx Formulas A A Data = Review = = Ez View = Q- Search Sheet Share Comments Ey O 4 . Sort Find & Treas X Filter Select 2 Wraa Text Merge & Center - - General $ -% Insert Delcte Format Formalingas Table Styles steun Non-Current Assets Long-term Investments Investments in equity Securitic Landheld for future cevelopm Property, Plant, and Equipment Buildings Less: Accumulate Depreciatic Intargil AS Capitalized Development Cost Goudwill Other dans la lintang A Total Non Current Assets Total Assets steps step 6 step 7 steu sten 7 Use calculated A/P turnover from ratios steus stea steus stea step 9 stev 10 Current Liabilities Accounts payable Salary and Wapas Payable nterest Payable Uneaed Revenue income Tax payable Property taxes payable Utilities payable Total Current Liabilities Non Current Liabilities Notes peyable Pravidians Rated to Pandans Bands Payable Total Non-Current Liabilities Total Liabilities Stockholders' Equity Common Stock Preferred SockSX dividendi Pald-in capital Comman Stock Paid-in-capital-Preferred Stuck Recained Farrings Accumulated Other Comprehens Less Treasury Stock Total Stockholders' Equity Total Liabilities and Stockholders' Equity sten 12 Stan 12 sen 12 Ste 11 FS's Ratios Projected FS Select destination and press ENTER or choose Paste # E 2 - + 100%