Question Details

(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

 

Addition to Retained Earnings =

 

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:

Pay using PayPal (No PayPal account Required) or your credit card . All your purchases are securely protected by .
SiteLock

About this Question

STATUS

Answered

QUALITY

Approved

DATE ANSWERED

Oct 15, 2019

EXPERT

Tutor

ANSWER RATING

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.

NEW ASSIGNMENT HELP?

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.

Order Now