Question Details

(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.

 

Grading

 

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
Answered
QUALITY
Approved
ANSWER RATING

This question was answered on: Jan 30, 2021

PRICE: $15

Solution~0001000744.zip (25.37 KB)

Buy this answer for only: $15

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)

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

Jan 30, 2021

EXPERT

Tutor

ANSWER RATING

GET INSTANT HELP/h4>

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