70.2K

Verified Solution

Link Copied!

Do in excel and show forumulas and responses please

For the exercise below, please complete the assignment by creating a spreadsheet using the method demonstrated in the video series. Once it is complete, attach the file below. DO NOT attach a PDF. It will be graded as a zero. You must show your work which means there must be formulas in your Excel file, not just numbers, The balance sheet and income statement for ABC Company for the years 2015 and 2016 are as follows. ABC Company BALANCE SHEET 2015 2016 Cash $710 $250 Accounts receivable 570 620 Inventory 1.200 730 Total Assets $2.480 81.600 Accounts payable $680 $440 Notes payable 659 250 Common stock 450 210 Retained earnings 700 700 Total liabilities and stockholders equity 52.480 $1,600 INCOME STATEMENT Net Sales $950 $940 Cost of goods sold 120 210 Gross margin 830 Expenses Salaries $100 $150 Warehousing costs 80 120 Advertising 460 650 Taxes 85 Total expenses $685 $1.005 Net Income $145 ($275) 730 Question Perform vertical and horizontal analysis of the statements and identify two things that appear to be unusual and could be possible symptoms of fraud. Each student shall use the method shown in the video series A- % For the exercise below, please complete the assignment by creating a spreadsheet using the method demonstrated in the video series. Once it is complete, attach the file below. DO NOT attach a PDF. It will be graded as a zero. You must show your work which means there must be formulas in your Excel file, not just numbers The balance sheet and income statement for ABC Company for the years 2015 and 2016 are as follows: ABC Company 250 BALANCE SHEET 2015 2016 Cash $710 $250 Accounts receivable 570 620 Inventory 1.200 230 Total Assets $2.480 $1,600 Accounts payable $680 $440 Notes payable 650 Common stock 450 210 Retained earnings 700 700 Total liabilities and stockholders' equity $2.480 81.600 INCOME STATEMENT Net Sales $950 $940 Cost of goods sold 120 210 Gross margin 830 730 Expenses Salaries $100 $150 Warehousing costs 80 120 Advertising 460 650 Taxes 45 85 Total expenses $685 $1.005 Net Income $145 ($275) Question: Perform vertical and horizontal analysis of the statements and identify two things that appear to be unusual and could be possible symptoms of fraud. Each student shall use the method shown in the video series

Answer & Explanation Solved by verified expert

See Answer