## (solution) FIN 201 Fundamentals of Financial Management Excel Spreadsheet

Please fill out the answers in the provided excel spreadsheet below. The questions are under excel assignment 2 info

FIN 201 Fundamentals of Financial Management

Excel Spreadsheet Problem #2 - Chapter 4 Background

The spreadsheet problems in FIN 201 are designed to help you develop your Excel expertise. Key learning outcomes for this proble

·

Constructing appropriate Excel formulas

·

Understanding and appropriately applying relative and absolute cell references within formulas.

Instructions

This exercise is based on the data in Problem 4-246 (page 130-132 of the text).

Use Excel formulas and appropriate cell references to calculate the 10 financial ratios and report in the highlighted Template.

Each question is worth 20 points. The points will be determined from the following rubric:

o 10 Points - Accuracy of the spreadsheet and appropriate formulas (including cell references) are used to determine cell entries

o 10 Points - Format and cosmetic appearance of the spreadsheet. Academic Integrity

Start with the accompanying spreadsheet and work individually to complete this assignment.

Copying any part of your spreadsheet from another student, or allowing any part of your spreadsheet to be copied by another student l expertise. Key learning outcomes for this problem are: ces within formulas. tios and report in the highlighted Template. g rubric:

ell references) are used to determine cell entries ssignment.

f your spreadsheet to be copied by another student, will result in an academic integrity violation. Student's Full Name:

Student's ID:

Section #:

Corrigan Corporation's December 31 Balance Sheets

Assets

Cash

Accounts receivable

Inventories

Total current assets

Land and building

Machinery

Other fixed assets

Total assets

Liabilities and equity

Accounts and notes payable

Accrued liabilities

Total current liabilities

Long-term debt

Common stock

Retained earnings

Total liabilities and equity

Corrigan Corporation's December 31 Income Statements

Sales

Cost of goods sold

Gross operating profit

General admin. and selling expenses

Depreciation

Miscellaneous

EBT

Taxes (40%)

Net income

Per-Share Data

EPS

Cash dividends

Market price (average)

P/E ratio

Number of shares outstanding

Ratio Analysis

Liquidity

Current ratio

Asset Management

Inventory turnoverb

Days sales outstandingc

Fixed assets turnoverb

Total assets turnoverb

Profitability

Return on assets

Return on equity

Profit margin

Debt Management \$ \$ \$ \$

\$ \$ \$

\$ \$

\$ 2012

72,000 \$

439,000

894,000

1,405,000 \$

238,000

132,000

61,000

1,836,000 \$ 2011

65,000

328,000

813,000

1,206,000

271,000

133,000

57,000

1,667,000 432,000 \$

170,000

602,000 \$

404,290

575,000

254,710

1,836,000 \$ 409,500

162,000

571,500

258,898

575,000

261,602

1,667,000 2012

4,240,000

3,680,000

560,000

236,320

159,000

134,000

30,680

12,272

18,408 2011

3,635,000

2,980,000

655,000

213,550

154,500

127,000

159,950

63,980

95,970 \$

\$ \$

\$ 2012

\$0.80

\$1.10

\$12.34

15.43

23,000 2011

\$4.17

\$0.95

\$23.57

5.65

23,000 2012 2011 Debt-to-assets ratio

Market Value

P/E ratio

a

Industry average ratios have been constant for the past 4 years.

b

Based on year-end balance sheet figures.

c

Calculation is based on a 365-day year. Industry Avga

2.7

7.0

32

13.0

2.6

9.1%

18.2%

3.5% 50.0%

6.0

Solution details:
STATUS
QUALITY
Approved

This question was answered on: Jan 30, 2021

Solution~0001000744.zip (25.37 KB)

This attachment is locked

We have a ready expert answer for this paper which you can use for in-depth understanding, research editing or paraphrasing. You can buy it or order for a fresh, original and plagiarism-free solution (Deadline assured. Flexible pricing. TurnItIn Report provided)

STATUS

QUALITY

Approved

Jan 30, 2021

EXPERT

Tutor