I need help figuring out the ratios im seriously struggling. thank you in advance
AutoSave On ACC 308 Final Project Workbook Last Modified: 21m ago Search Suzic McCracken SM CG File Home Insert Page Layout Formulas Data Review View Help Share Comments Arial 12 ~ A AutoSum - == == PM 9 Wrap Text Number 27 o Fah) Peste la copy X Out [ Format Painter Cipboard BIU OA Insert Delete Format SE Merge & Center $ -% -% Clear Conditional Formatas Cell Formatting Table Styles Styles Sort & Find & Filter Select Eciting Analyze Data Font Alignment Number Colls Analysis D15 X > A B F H K K L M N o P R S T 4 E Peyton Approved Ratio Analysis 5 6 2017 2016 Current Ratio (Working Capital) 5.78 5.18 Quick Ratio 5.56 4.99 A/R Tumover 5.91 5.53 Inventory Tumover Gross Margin 7 8 9 10 11 12 13 14 15 16 17 19 19 20 21 22 23 24 25 26 27 78 29 Return on Sales Return on Equity Return on Assets Cash Flow 2017 Revised Balance sheet 2015 Balance Sheet 2016 Income Statement 2016 Ratio Analysis Milestone Two Instructions Pro Forma IS Pro Forma ks Reacy F 1009 0 11:34 PM 11/12/2021 AutoSave On ACC 308 Final Project Workbook Last Modified: 23m ago Search Suzic McCracken SM File Home Insert Page Layout Formulas Data Review View Help Share Comments 11 - A A AutoSum - == == 99 Wrap Text General 72 Fah) Peste la copy X Out [ Format Painter Clipboard Calibri BIU OA, EI Merge & Center $ % 68 Insert Delete Format Clear Conditional Formalas Cell Formatting Table Styles Styles Sort & Find & Filter Select Eciting Analyze Data Font Alignmen Number Colls Analysis DS A B C D F G H ! J K L M M N P 0 R S S T U v W X Peyton Approved Income Statement for Year Ended 12/31/2016 1 1 2 3 4 4 5 5 6 7 a 9 10 11 12 13 14 15 214,256.48 770.76 215,027.24 Bakery Sales Merchandise Sales Total flevenues Cost of Goods Sold-Baked Cost of Goods Sold - Merchandise Total cost of Goods Sold Gross Profit 73,159.59 549.64 73,709.23 141,818.01 16 17 Operating Expenses: 18 19 20 21 22 23 24 25 26 27 28 Rent Expense Wages Expense Misc. Supplies Expense Business License Expense Misc. Expense Depreciation Expense Insurance Expense Advertising Expense Interest Expense Telephone Expense Total Operating Expenses: 15,694.23 6.821.76 1,668.18 1,307.85 871.9 433.36 697.52 740.74 523.14 313.88 29,072.56 30 31 Net Income Cash Flow 2017 Revised Balance sheet 2015 112,745.45 Balance Sheet 2016 Income Statement 2016 Ratio Analysis Milestone Two Instructions Pro Forma IS Pro Forma KS Reacy FI 90% 40 11:36 PM 11/12/2021 AutoSave On ACC 308 Final Project Workbook Last Modified: 24m ago Search Suzic McCracken SM CG File Home Insert Page Layout Formulas Data Review View Help Share Comments AutoSum Calibri 11 == == PR - PA 29 Wrap Text General 47 X out Ih Copy Paste Format Painter Cipboard Fah) LEN Analyze Data Insert Delete Format OA BIU E. Merge & Center $ -% -% Clear Conditional Formalas Cell Formatting Table Styles Styles Sort & Find & Filter Select Font Alignment Number Colls Editing Analysis J33 X > f G H 1 K L M N N 0 P R R S 1 w w X D Peyton Approved Balance Sheet As of December 31, 2016 Liabilities and Owners' Equity Current Liabilities: Accounts Payable Wages Payable Interest Payable 16,970 00 1,532.00 166.50 4A 0 1 2 2 3 4 5 Assets 6 Current Assets 7 Cash Accounts Receivable 9 Baking Suppies 10 Merchandise Inventory 11 Prepaid Rent 12 Prepaid insurance 13 Misc Supplies 14 15 16 Total Current Ass 17 18 19 Long Term Fixed Assets: 20 Baking Equipment 21 Accumulated Depreciation 22 Net Fixed assets 43165 39 42,633.00 7.318.88 794.97 1,665.00 1,110 DO 55.50 96,742.72 Total Current Liabilities 18.669.30 Long Term Liabilities: Notes Payable Total Long Term Liabilities: 15,000.00 8,000.00 92858 15,000.00 7,071.42 Total Liabilities 33,669.30 Common Stock Retained Earnings 20,000.00 50,144.84 27 Total Equity 70,144 84 Total Assets 103,814.14 Total Liabilities & Equity 103,814.14 80 21 32 33 Cash Flow 2017 Revised Balance sheet 2015 Balance sheet 2016 Income Statement 2016 Ratio Analysis Milestone Two Instructions Pro Forma IS Pro Forma RS Reacy FI 80% 11:36 PM 11/12/2021 AutoSave On ACC 309 Final Project Workbook - Last Modified: Yesterday at 11:12 PM - O Search Suzic McCracken SM CG File Home Insert Page Layout Formulas Data Review View Help Share Comments AutoSum Arial 12 - A A 47 Fah) X Out [Copy Paste Format Painter Cipboard == == PM 29 Wrap Text SEE Merge & Center Accounting $ -% -23 O A Insert Delete Format BIU Clear Conditional Formatas Cell Formatting Table Styles Styles Sort & Find & Filter Select Eciting Analyze Data Font Alignment Number Colis Analysis D29 -D16+D22 G H 1 M N P R S T U v w D E. Peyton Approved Balance Sheet As of December 31, 2015 4A B 1 2 3 4 5 Assets s 6 Current Assets: 7 Cash Accounts Receivable 9 Baking Supplies 10 Merchandise Inventory 11 Prepaid Rent 12 Prepaid Insurance 13 Misc Supplies 14 IS 16 Total Current Assets 17 Liabilities and Owners' Equity Current Liabilities: Accounts Payable 1503884 Wages Payable 1119.93 Interest Payable 121.53 31507.58 35118.97 8012.23 580.27 121532 B10 21 40.51 77,315.09 Total Current Liabilities 16,327,20 18 19 20 21 Long Term Fixed Assets: Baking Equipment Accumulated Deprec Net Fixed assets Long Term Liabilities: Notes Payable 10,000.00 Total Long Term Liabilities: 10,000.00 6000 -57779 22 5.322.21 Total Liabilities: 26,327.20 Common Stock Retained Earnings 20,000.00 36 310.10 Total Equity 58,310.10 24 25 26 27 28 29 30 31 32 Total Assets 82,637.30 Total Liabilities & Equity 82,637.30 Retained Earnings 2017 Retained Earnings 2017 Revised Cash Flow 2017 Cash Flow 2017 Revised Balance sheet 2015 Balance Sheet 2016 Income Statement 2016 Ratio Analysis .. + Ready E 304 5:25 PM 11/13/2021 AutoSave On ACC 308 Final Project Workbook Last Modified: 24m ago Search Suzic McCracken SM File Page Layout Formulas Data Review View Help Share Comments Calibri w 11 - A A AutoSum - == == PM 9 Wrap Text General 27 Fah) Home Insert X Out [ Format Painter Clipboard Paste C Copy BIU-- OA Merge & Center $ -% -% Insert Delete Format Clear Conditional Formatas Cell Formatting Table Styles Styles Sort & Find & Filter Select Analyze Data Font Alignmen Number Colls Editing Analysis H23 A B C D E F G H 1 K L M N P 0 R S 1 Milestone One Workbook Instructions Revised Peyton Approved Statement of Retained Earnings for Year Ended 12/31/2017 Beginning Balance: plus Net Income $ 50,144.84 175,476.18 2 2 3 4 5 6 7 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 74 25 26 less Dividends: : Ending Balance (105,000.00) $ 120,621.02 Balance Sheet 2017 Revised Income Statement 2017 Income Statement 2017 Revised Retained Earnings 2017 Retained Earnings 2017 Revised Cash Flow 2017 Cash Flow 2017 Revisi + Reacy 1009 A. (0 ) 11:37 PM 11/12/2021 AutoSave On Del ACC 308 Final Project Workbook Last Modified: 24m ago Search Suzic McCracken SM CG File Home Insert Page Layout Formulas Data Review View Help Share Comments AutoSum Arial 12 - A A A == PR 99 Wrap Text 27 Fah) Peste la copy X Out [ Format Painter Accounting $ -% -23 BIU O A Insert Delete Format Merge & Center Clear Conditional Formalas Cell Formatting Table Styles Styles Sort & Find & Filter Select Analyze Data Clipboard Font Alignmen Number Colis Editing Analysis D10 X -'Trial Balance 2017'!010 B K L M N 0 5 T U V 4 3 3 4 F G Peyton Approved Balance Sheet As of December 31, 2017 S Assets 7 8 8 9 10 11 12 13 14 Liabilities and Owners' Equity Current Liabilities: Accounts Payable 23,137.11 Wages Payable 3,38328 Interest Payable 211 46 Customer Deposit 1,000.00 Current Assets Cash Accounts Receivable Other Receivable Insurance Baking Supplies Merchandise Inventory Consignment Inventory Prepaid Rent Prepaid Insurance Misc Supplies 68,520.01 68,519.91 70000 18,661.70 1,038 07 200.00 2,114.56 2,114 55 170.49 15 16 17 18 19 20 21 Total Current Assets 162,059.31 Total Current Liabilities 28.031.85 Long Term Liabilities: Notes Payable Total Long Term Liabilities: 5,000.00 Long Term Fixed Assets: Baking Equipment Accumulated Depreciabon Net Fixed assets 24 5.000.00 12,000.00 (405.44) 25 26 27 11,693.66 Total Liabilities: 33,031.85 Common Stock Retained Earnings 20,000.00 $ 120,621.02 Total Equity 140,621.02 30 31 22 22 34 Total Assets: $173,652.87 Total Liabilities & Equity $ 173,652.87 Balance Sheet 2017 Revised Income Statement 2017 Income Statement 2017 Revised Retained Earnings 2017 Retained Famings 2017 Revised Cash Flow 2017 Cash Flow 2017 Revisi + Ready 80% O 11:37 PM 11/12/2021 AutoSave On ACC 308 Final Project Workbook Last Modified: 31m ago Search Suzic McCracken SM CG File Home Insert Page Layout Formulas Data Review View Help Share Comments - AutoSum w 11 - A == PM 29 Wrap Text General 47 Fah) X Out [b Copy Paste Format Painter Clipboard Calibri BIU O A $ -% -% 999 Insert Delete Format Merge & Center Clear Conditional Formatas Cell Formatting Table Styles Styles Sort & Find & Filter Select Editing Analyze Data Font Alignment Number Colis Analysis B12 X C F G H K L M N 0 R 5 T 4 4 5 0 7 8 9 9 Peyton Approved Income Statement for Year Ended 12/31/2017 i $ 327 322.55 1 205 54 10 328,528.19 Hakery Sales Merchandise Sales Total Revenues Cost of Goods Sold-Baked Cost of Goods Sold - Merchandise Total Cost of Goods Sold Gross Profit 105.834.29 859.77 (105,594.06) 221,834.13 12 13 14 15 70 17 18 19 20 21 Operating Expenses: 23 24 25 Rent Experise Wages Experise Misc. Suppies Expense Business License Expers Misc Experee Depreciation Expense Insurance Expense Advertising Expense Interest Expense Telephone Expense Gair Loss on disposal of equipment Total Operating Expenses: 24,549.19 10.670.72 3.000.46 2045 // 1,363 84 677.66 1.091.08 1,549.74 818.31 490 90 100.00 27 46,357,95 29 30 31 22 23 34 35 36 Net Income 175,476.18 Balance Sheet 2017 Revised Income Statement 2017 Income Statement 2017 Revised Retained Earnings 2017 Retained Famings 2017 Revised Cash Flow 2017 + Cash Flow 2017 Revisi EI Ready 80% 0 1 11:44 PM 11/12/2021
