Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

I need help fixing what i did incorrectly. The green is correct yellow is incorrect. Chapters 7 & 8 Worksheet Assignment Fill in the yellow

I need help fixing what i did incorrectly. The green is correct yellow is incorrect.
Chapters 7 & 8 Worksheet Assignment
Fill in the yellow cells with the appropriate functions/formulas.
Do not type in the numerical answer. Let Excel calculate the number using your formula in the cell.
Balance Sheet ($million)
\table[[,2020,2019],[Cash,24,20],[Accounts receivable,360,300],[Inventory,360,400],[Total Current Assets,744,720],[Gross Plant & Equip.,810,650],[-Accumulated deprciation,210,150],[Net Plant & Equip.,600,500],[Total Assets,1,344,1,220]]
\table[[,,],[Accounts Payble,216,2019],[Notes Paybable,134,103],[Accrued wages&taxes,144,120],[Total Current Llab.,494,403],[Long-term debt/bonds,300,300],[Common stock,100,100],[Retained earnings,450,417],[Total Stockhidr Equity,550,517],[Total Liab. and Equity,1,344,1,220]]
Income Statement ($million)
\table[[Net sales (all credit),2400.0,2000.0],[Cost of goods sold,2040.0,1700.0],[Depreciation,60.0,50.0],[EBIT,300.0,250.0],[interest,43.4,40.4],[EBT,256.6,209.6],[taxes,102.6,83.8],[Net Income,154.0,125.8],[Common dividends,121.0,8.8]]
\table[[Additional information:],[Average Tax Rate =,40%
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_2

Step: 3

blur-text-image_3

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

Distressed Debt Analysis Strategies For Speculative Investors

Authors: Stephen Moyer

1st Edition

1932159185, 978-1932159189

More Books

Students also viewed these Finance questions

Question

background of h.r 4128 payment of choice act of 2023

Answered: 1 week ago

Question

3. Identify the methods used within each of the three approaches.

Answered: 1 week ago