50.1K

Verified Solution

Link Copied!

Need help answering these question

AutoSave Off HI m1_assessment2_datasheet (2) - Excel Search Kevin James KJ File Home Insert Page Layout Formulas Data Review View Help Acrobat Share Comments Insert Calibri 11 . AP == ab Wrap Text General 28 O s LIV Paste BIU A E E Merge & Center 2X Delete Format $ %, -20 y Ideas Sensitivity Conditional Format as Cell Formatting Table Styles Styles Sort & Find & Filter Select Editing Clipboard Font Alignment Number Cells Ideas Sensitivity A38 X A B E F G . J K 1 RC 5-15 MT 480 Unit 3 Case Study Smith Loan Reviev Data for Teams 2 XYZ Bank told Bob to increase cash to $70,000 from 2016 to 2017. But cash increased from $16,566 in 2016 to just $33,411 in 2017, well short of $70,000. Comparative Balance Sheets and Cash Flow Statement Worksheet 3 4 5 ASSETS Cash and marketable securities 2017 2016 Did Cash Go Up or Down? $ $ 33,411 $ $ 16,566 S 16,845 Denial Le 6 7 8 A/R went down (good or bad for cash?) Accounts Receivable $ 260,205 S 9 10 318,768s The arrows present account balance. The highlighted accounts the denial letter sent For example, the bal went down by $58,5 will analyze the sign present that informa letter Inventory S 423,819 S 352,740 S 58,563 You collected outstanding Accounts Rec (quickly) Explain 2/10 net 30 payment terms (71,079) You built up/have more inventory on hand in 2014 Explain Economic Order Quantity (EOQ) (11.339) (40.700) 12 13 S 14 15 16 Other current assets Total Current Assets S $ 41.251 758.686 29.912 5 717.986 $ Explain how the six highlighted accounts impacted cash flow from one year to the next. The accounts either added or reduced the cash balance from one year to the next. I.e., the accounts were either a Source or Use of cash. Plant Property and Equipment $ 1,512.675 $ 1,403,220 $ *Note: There are no you must decide wh if you were a team a: 17 18 19 20 21 22 (109.455) You bought PP&E in 2017 explain MACRS 30.420 (119.735) Goodwill and other assets Total Assets LIABILITIES AND EQUITY S 382.145 $ 2,653,506 S 412.565 5 $ 2.533.771 This one worksheet provides all the data you need to complete the project. You may want to assign each team member a respective 'Explain'. 23 332,004 S 46,232 You owe vendors money but have not paid them yet Accounts Payable $_378,236 S Cash Flow Data M1 Assessment 2 Sheet2 Sheet3 + + 70% Type here to search o i oo E e ? 9:52 AM 6/30/2020 AutoSave Off HI m1_assessment2_datasheet (2) - Excel Search Kevin James KJ File Home Insert Page Layout Formulas Data Review View Help Acrobat Share Comments Insert Times New Roman 12 - A == ab Wrap Text General AY O 5 LIV Paste BIU C-A- E E Merge & Center 2X Delete Format $ % -29 y Ideas Sensitivity Conditional Format as Cell Formatting Table Styles Styles Sort & Find & Filter Select Editing Clipboard Font Alignment Number Cells Ideas Sensitivity A18 A B C D E F G H J K Source or Use of cash. explain MACRS ir you were a team as 18 19 20 21 22 Goodwill and other assets Total Assets LIABILITIES AND EQUITY $ 382.145 $ 2.653.506 $ 412.565 $ 2.533.771 30,420 (119.735) This one worksheet provides all the data you need to complete the project. You may want to assign each team member a respective 'Explain'. Accounts Payable $ 378,236 S 332,004 S 23 24 25 46,232 You owe vendors money but have not paid them yet What is a Mechanios Lien Wages Payable Accrued income taxes Total Current Liabilities S 14,487 7.862 $ S 21.125 S 16.815$ $ $ 413.848 $ 356.681 $ 6,625 What is the Acorual Accounting concept here? 4.310 57.167 Long-Term Debt: Bank Notes $ 679,981 793,515 S 26 27 28 29 30 31 32 33 34 35 36 Total Liabilities Total Common Equity Total Liabilities and Equity $ 1,093,829 $ 1,559,677 $ 2.653.506 $ 1,150.196 $ 1,383.575 $ 2,533,771 (113,534) The loan balance went down during 2014 ----explain collateral and UCC1forms (56,367) 176,102 119.735 addi tion , it was repo rted that the com Cash Flow Data M1 Assessment 2 Sheet2 Sheet3 + 70% Type here to search o i E e ? 9:52 AM 6/30/2020 AutoSave Off Havel m1_assessment2_datasheet (2) - Excel Search Kevin James KJ File Home Insert Page Layout Formulas Data Review View Help Acrobat Share Comments Insert Times New Roman 12 - A = 2 Wrap Text General 48 0 9X Delete LIV Paste BIU A Es Merge & Center y Ideas $ %): Sensitivity Format Conditional Format as Cell Formatting Table Styles Styles Sort & Find & Filter Select Editing Clipboard Font Alignment Number Cells Ideas Sensitivity A37 fox In addition, it was reported that the company had a net income of $3,155,848 and depreciation expenses were equal to $212,366 during 2014. A . J K B Total Liabilities and Equity $ 2,653,506 E F $ 2.533.771 119.733 34 35 36 addi tion .it was repo rted that the com pan Y had 2 net inco me of $3,1 55,8 48 and depr ecia tion 37 exp 38 39 Net Income $3,155,848 Depreciation $212,366 Cash Flow Data M1 Assessment 2 Sheet2 Sheet3 + 70% Type here to search E e ? 9:52 AM 6/30/2020 AutoSave Off HI m1_assessment2_datasheet (2) - Excel Search Kevin James KJ File Home Insert Page Layout Formulas Data Review View Help Acrobat Share Comments Insert Calibri 11 . AP == ab Wrap Text General 28 O s LIV Paste BIU A E E Merge & Center 2X Delete Format $ %, -20 y Ideas Sensitivity Conditional Format as Cell Formatting Table Styles Styles Sort & Find & Filter Select Editing Clipboard Font Alignment Number Cells Ideas Sensitivity A38 X A B E F G . J K 1 RC 5-15 MT 480 Unit 3 Case Study Smith Loan Reviev Data for Teams 2 XYZ Bank told Bob to increase cash to $70,000 from 2016 to 2017. But cash increased from $16,566 in 2016 to just $33,411 in 2017, well short of $70,000. Comparative Balance Sheets and Cash Flow Statement Worksheet 3 4 5 ASSETS Cash and marketable securities 2017 2016 Did Cash Go Up or Down? $ $ 33,411 $ $ 16,566 S 16,845 Denial Le 6 7 8 A/R went down (good or bad for cash?) Accounts Receivable $ 260,205 S 9 10 318,768s The arrows present account balance. The highlighted accounts the denial letter sent For example, the bal went down by $58,5 will analyze the sign present that informa letter Inventory S 423,819 S 352,740 S 58,563 You collected outstanding Accounts Rec (quickly) Explain 2/10 net 30 payment terms (71,079) You built up/have more inventory on hand in 2014 Explain Economic Order Quantity (EOQ) (11.339) (40.700) 12 13 S 14 15 16 Other current assets Total Current Assets S $ 41.251 758.686 29.912 5 717.986 $ Explain how the six highlighted accounts impacted cash flow from one year to the next. The accounts either added or reduced the cash balance from one year to the next. I.e., the accounts were either a Source or Use of cash. Plant Property and Equipment $ 1,512.675 $ 1,403,220 $ *Note: There are no you must decide wh if you were a team a: 17 18 19 20 21 22 (109.455) You bought PP&E in 2017 explain MACRS 30.420 (119.735) Goodwill and other assets Total Assets LIABILITIES AND EQUITY S 382.145 $ 2,653,506 S 412.565 5 $ 2.533.771 This one worksheet provides all the data you need to complete the project. You may want to assign each team member a respective 'Explain'. 23 332,004 S 46,232 You owe vendors money but have not paid them yet Accounts Payable $_378,236 S Cash Flow Data M1 Assessment 2 Sheet2 Sheet3 + + 70% Type here to search o i oo E e ? 9:52 AM 6/30/2020 AutoSave Off HI m1_assessment2_datasheet (2) - Excel Search Kevin James KJ File Home Insert Page Layout Formulas Data Review View Help Acrobat Share Comments Insert Times New Roman 12 - A == ab Wrap Text General AY O 5 LIV Paste BIU C-A- E E Merge & Center 2X Delete Format $ % -29 y Ideas Sensitivity Conditional Format as Cell Formatting Table Styles Styles Sort & Find & Filter Select Editing Clipboard Font Alignment Number Cells Ideas Sensitivity A18 A B C D E F G H J K Source or Use of cash. explain MACRS ir you were a team as 18 19 20 21 22 Goodwill and other assets Total Assets LIABILITIES AND EQUITY $ 382.145 $ 2.653.506 $ 412.565 $ 2.533.771 30,420 (119.735) This one worksheet provides all the data you need to complete the project. You may want to assign each team member a respective 'Explain'. Accounts Payable $ 378,236 S 332,004 S 23 24 25 46,232 You owe vendors money but have not paid them yet What is a Mechanios Lien Wages Payable Accrued income taxes Total Current Liabilities S 14,487 7.862 $ S 21.125 S 16.815$ $ $ 413.848 $ 356.681 $ 6,625 What is the Acorual Accounting concept here? 4.310 57.167 Long-Term Debt: Bank Notes $ 679,981 793,515 S 26 27 28 29 30 31 32 33 34 35 36 Total Liabilities Total Common Equity Total Liabilities and Equity $ 1,093,829 $ 1,559,677 $ 2.653.506 $ 1,150.196 $ 1,383.575 $ 2,533,771 (113,534) The loan balance went down during 2014 ----explain collateral and UCC1forms (56,367) 176,102 119.735 addi tion , it was repo rted that the com Cash Flow Data M1 Assessment 2 Sheet2 Sheet3 + 70% Type here to search o i E e ? 9:52 AM 6/30/2020 AutoSave Off Havel m1_assessment2_datasheet (2) - Excel Search Kevin James KJ File Home Insert Page Layout Formulas Data Review View Help Acrobat Share Comments Insert Times New Roman 12 - A = 2 Wrap Text General 48 0 9X Delete LIV Paste BIU A Es Merge & Center y Ideas $ %): Sensitivity Format Conditional Format as Cell Formatting Table Styles Styles Sort & Find & Filter Select Editing Clipboard Font Alignment Number Cells Ideas Sensitivity A37 fox In addition, it was reported that the company had a net income of $3,155,848 and depreciation expenses were equal to $212,366 during 2014. A . J K B Total Liabilities and Equity $ 2,653,506 E F $ 2.533.771 119.733 34 35 36 addi tion .it was repo rted that the com pan Y had 2 net inco me of $3,1 55,8 48 and depr ecia tion 37 exp 38 39 Net Income $3,155,848 Depreciation $212,366 Cash Flow Data M1 Assessment 2 Sheet2 Sheet3 + 70% Type here to search E e ? 9:52 AM 6/30/2020

Answer & Explanation Solved by verified expert

See Answer