Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Help solve by using excel In cell B 4 4 , calculate the net working capital for 2 0 1 7 . In cell B

Help solve by using excel
In cell B44, calculate the net working capital for 2017.
In cell B45, calculate the debt ratio for 2017.
Copy cell B44:B45 and paste onto cells C44:C45.
To prepare the common-sized income statement, find the ratio between each account in the income statement and the sales amount.
In cell B49, divide the sales amount by the sales datum in cell E30 and make an absolute cell reference to the sales datum for copying and pasting purposes.
Copy cell B49 and paste onto the cell ranges B50:B51 and B54:B58.
In cell B52, divide the selling, general, and administrative expense by the sales datum in cell E30 and make an absolute cell reference to the sales datum for copying and pasting purposes.
Copy cell B52 and paste onto the cell B53.
To prepare the common-sized balance sheet, find the ratio between each account in the balance sheet and the total of the balance sheet.
In cell B62, divide the accounts receivable amount by the total assets datum in cell C16 and make an absolute cell reference to the total assets datum for copying and pasting purposes.
Copy cell B62 and paste onto the cells B63:B69.
In cell B71, divide the accounts payable amount by the total liabilities and owners' equity datum in cell C26 and make an absolute cell reference to the total liabilities and owners' equity datum for copying and pasting purposes.
Copy cell B71 and paste onto the cell ranges B72:B74 and B76:B79.
In cell C83, input the net income amount.
Note: The output of the expression or function you typed in this cell is expected as a positive number in case of cash inflow and as a negative number in case of cash outflow.
In cell B84, input the depreciation expense.
Note: The output of the expression or function you typed in this cell is expected as a positive number in case of cash inflow and as a negative number in case of cash outflow.
In cell B85, calculate the decrease in accounts receivable.
Note: The output of the expression or function you typed in this cell is expected as a positive number in case of cash inflow and as a negative number in case of cash outflow.
In cell B86, calculate the increase in inventory.
Note: The output of the expression or function you typed in this cell is expected as a positive number in case of cash inflow and as a negative number in case of cash outflow.
In cell B87, calculate the decrease in account payable.
Note: The output of the expression or function you typed in this cell is expected as a positive number in case of cash inflow and as a negative number in case of cash outflow.
In cell C88, input the function SUM to calculate the net cash provided by operating activities.
Note: The output of the expression or function you typed in this cell is expected as a positive number in case of cash inflow and as a negative number in case of cash outflow.
In cell C90, calculate the increase in plant and equipment.
Note: The output of the expression or function you typed in this cell is expected as a positive number in case of cash inflow and as a negative number in case of cash outflow.
In cell B92, calculate the increase in notes payable.
Note: The output of the expression or function you typed in this cell is expected as a positive number in case of cash inflow and as a negative number in case of cash outflow.
In cell B93, calculate the dividends amount.
Note: The output of the expression or function you typed in this cell is expected as a positive number in case of cash inflow and as a negative number in case of cash outflow.
In cell C94, input the function SUM to calculate the net cash provided by financing activities.
Note: The output of the expression or function you typed in this cell is expected as a positive number in case of cash inflow and as a negative number in case of cash outflow.
In cell C95, calculate the net decrease in cash.
Note: The output of the expression or function you typed in this cell is expected as a positive number in case of cash inflow and as a negative number in case of cash outflow.
In cell C96, input the beginning cash amount.
In cell C97, calculate the ending cash amount.
image text in transcribed

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Financial Accounting

Authors: Paul D. Kimmel, Jerry J. Weygandt, Donald E. Kieso

2nd Edition

047116920X, 978-0471169208

More Books

Students also viewed these Accounting questions

Question

Am I prejudiced against this person? Am I too judgmental?

Answered: 1 week ago