Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Complete the stops below using cell references to given data or previous calculations. In some cases, a simple cell reference is all you need. To

image text in transcribed
image text in transcribed
image text in transcribed
image text in transcribed
image text in transcribed
image text in transcribed
Complete the stops below using cell references to given data or previous calculations. In some cases, a simple cell reference is all you need. To copypaste a fammla across a row or down a columin, an absolute cell reference or a mixed cell refenence may be preferred. If a specific Excel function is to be used, the directions will specify the use of that finction. Do not tope in numerical data into a cell or finction. Insfead, make a reference to the cell in which the data is fousd. Make your computations only in the blue cells highlighred below. In all cases, urtass othenvise directed, wse the eariest appearance of the data in yora formulas, usually the Given Data section. DATA \begin{tabular}{|l|r|r|} \hline Accounts payable & $85,000 & $90,000 \\ \hline Accrued liabilities & 68,000 & 63,000 \\ \hline Total current debt & 153,000 & 153,000 \\ \hline Mortgage payable & 70,000 & 0 \\ \hline Preferred stock & 0 & 120,000 \\ \hline Common stock & 205,000 & 205,000 \\ \hline Retained earnings & 45,000 & 47,000 \\ \hline Total debt and equity & $473,000 & $525,000 \\ \hline \end{tabular} Abrahams Manufacturing Company lncome Statement: \begin{tabular}{l|r|} \hline Sales & 2018 \\ Cost of goods sold & $184,000 \\ Gross profit & 60,000 \\ \hline Selling, gencral, and administrative expenses & $124,000 \\ Depreciation expense & 44,000 \\ Operating income & 26,000 \\ \hline lnterest expens & $54,000 \\ Earnings beforo taxes & 4,000 \\ \hline Taxes & $50,000 \\ Preferred stock dividends & 16,000 \\ Earnings avainble to cornon sharcholders & 10,000 \\ \hline \end{tabular} 3.13 43. SOLUTION 44 Abrahams Manufacturing Company Statement of Cash Flows: Cash Flow from Operating Activities Net lncome Adjustments Depreciation Increase in accounts receivable Decrease in imventory Increase in account payable Decrease in accrued liabilities Net cash provided by operating activities Cash Flow from Investing Activities Increase in gross fixed assets Cash Flow from Financing Activities Decrease in mortgage payable Increase in preferred stock Preferred stock dividends Common stock dividends Net cash provided by financing activities Net increase in cash Beginning cash Ending cash 2. In cell C46, calculate 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. (1 point) 3. In cell B48, 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 outilow. ( 1 point) 4. In cell B49, calculate the increase 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 intlow and as a negative number in case of cash outflow. ( 1 point) 5. In cell B50, calculate the decrease 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. (1 point) 6. In cell B51, calculate the increase in account payable. Note. The output of the expression or function you typed in this cell is expected as a positive number in case 7. In cell B52, calculate the decrease in accrued kiabilities. 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. ( 1 point) 8. In cell C53, 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. ( 1 point) 9. In cell C55, calculate the increase in gross fixed assets. 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. (1 point) 10. In cell B57, calculate the decrease in mortgage 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. (1 point) 11. In cell B58, calculate the increase in preferred stock. 13. In cell B60, input the common stock dividends. 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 outilow. (1 point) 14. In cell C61, 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 outfow. (Apoint) 15. In cell C62, calculate the net increase 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 outlow. (1 point) 16. In cell C63, input the beginning cash. Note The output of the expression or function you byed in this cell is expected as a positive mumber in case of cash inflow and as a negative number in case of cash outflow. (1 point) 17. In cell C6t, calculate the ending cash

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

Real Estate Finance And Investments

Authors: William Brueggeman, Jeffrey Fisher

13th Edition

0073524719, 9780073524719

More Books

Students also viewed these Finance questions