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.
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:
Corrigan Corporation's December 31 Balance Sheets
Total current assets
Land and building
Other fixed assets
Liabilities and equity
Accounts and notes payable
Total current liabilities
Total liabilities and equity
Corrigan Corporation's December 31 Income Statements
Cost of goods sold
Gross operating profit
General admin. and selling expenses
Market price (average)
Number of shares outstanding
Days sales outstandingc
Fixed assets turnoverb
Total assets turnoverb
Return on assets
Return on equity
Debt Management $ $ $ $
$ $ $
1,836,000 $ 2011
1,667,000 432,000 $
1,836,000 $ 409,500
23,000 2012 2011 Debt-to-assets ratio
Industry average ratios have been constant for the past 4 years.
Based on year-end balance sheet figures.
Calculation is based on a 365-day year. Industry Avga
This question was answered on: Jan 30, 2021
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 .
About this QuestionSTATUS
Jan 30, 2021EXPERT
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).
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.