## (Solved) U01a1 This Excel document contains unique details and cells

U01a1

This Excel document contains unique details and cells specific to the problems that you must use to derive your solutions. Where numeric solutions are expected, provide full detail of the process used to reach the solution using Excel. Where analysis is expected, use information from the textbook to inform your analysis, not replace it, incorporating creativity, critical thinking, and real-life perspectives. Cite all resource materials used in your analysis, using proper APA format.

A thorough, professional presentation of your analysis and results is an important consideration. Enhance your presentation skills by using applicable tools such as tables, graphs, diagrams, and commentary as appropriate in all assignments in this course.

UNIT 1: TEXTBOOK PROBLEMS

CHAPTER 2: PROBLEM 1

Current Assets

Net Fixed Assets

Current Liabilities

Long-Term Debt

\$7,300

\$26,200

\$5,700

\$12,900

Shareholder Equity =

Net Working Capital =

CHAPTER 2: PROBLEM 2

Sales

Costs

Depreciation Expense

EBIT

Interest Expense

EBT

Taxes @ 35%

Net Income =

Cash Dividends

Tax Rate =

Income Statement

\$675,300

\$297,800

\$45,100

\$20,700

\$62,000

35%

CHAPTER 2: PROBLEM 4

Taxable Income

\$315,000

Table 2.3

Income Taxes =

Average Tax Rate =

Marginal Tax Rate =

Taxable Income

Taxable Income (cont)

Tax Rate

0

50,001

75,001

100,001

335,001

10,000,001

15,000,001

18,333,334

50,000

75,000

100,000

335,000

10,000,000

15,000,000

18,333,333

+

15%

25%

34%

39%

34%

35%

38%

35%

(Note: No formula needed. Just inpu

CHAPTER 2: PROBLEM 5

Sales

Costs

Depreciation Expense

EBIT

Interest Expense

EBT

Taxes @ 40%

Net Income

Tax Rate

\$29,200

\$10,400

\$1,800

\$1,050

40%

Operating Cash Flow =

CHAPTER 3: PROBLEM 2

Debt/Equity Ratio

Return on Assets

Total Equity

0.65

9.80%

\$850,000

Equity Multiplier =

Return on Equity =

Net Income =

CHAPTER 3: PROBLEM 6

ROE

Payout Ratio

Retention Ratio

Sustainable Growth Rate =

16%

25%

(Note: You must calculate the retent

te: No formula needed. Just input the correct rate from the Tax Rate column.)

te: You must calculate the retention ratio first then the sustainable growth rate.)

Solution details:
STATUS
QUALITY
Approved

This question was answered on: Oct 15, 2019

Solution~000.zip (25.37 KB)

STATUS

QUALITY

Approved

Oct 15, 2019

EXPERT

Tutor

#### YES, THIS IS LEGAL

We have top-notch tutors who can do your essay/homework for you at a reasonable cost and then you can simply use that essay as a template to build your own arguments.

You can also use these solutions:

• As a reference for in-depth understanding of the subject.
• As a source of ideas / reasoning for your own research (if properly referenced)
• For editing and paraphrasing (check your institution's definition of plagiarism and recommended paraphrase).
This we believe is a better way of understanding a problem and makes use of the efficiency of time of the student.

### Order New Solution. Quick Turnaround

Click on the button below in order to Order for a New, Original and High-Quality Essay Solutions. New orders are original solutions and precise to your writing instruction requirements. Place a New Order using the button below.

WE GUARANTEE, THAT YOUR PAPER WILL BE WRITTEN FROM SCRATCH AND WITHIN A DEADLINE.