Interpreting financial statements | FNCE 3001 - Financial Management | Walden University - Minneapolis, MN

Interpreting Financial Statements marlon0510 Interpreting Financial Statements You will remember from the Week 1 Assignment that Medi-Supply is a small but growing company that sells medical devices to hospitals in the local area. The company wants to expand their distribution regionally and hopefully nationally with their innovative devices. They are looking for investors as well as seeking out potential banks to borrow funds for expansion. These investors require standardized financial statements and are very hesitant to get involved with any companies before ensuring their adherence to ethical business and financial practices, in order to avoid tarnishing their reputation. The owner of Medi-Supply has hired XYZ Corporation to provide consulting services to help them sort through their financial data, build their financial statements to display to potential investors and help them ensure they are on track with their goals and are avoiding any potential risks. You have been assigned to this project by your manager, Tim Lewis. Tim asks you to compile the results of your review into a series of reports, with detailed financial statements included. In Week 1, you completed a business report on the management goals and financial ethics of Medi-Supply company. This week, you will continue your work by preparing financial statements and a business report related to your findings.

To prepare for this Assignment:

  • Review this week’s Learning Resources.
  • Download the Week 2 Assignment Financial Statement Excel Template and the Week 2 Assignment Business Report Template. You will use both documents to complete this Assignment.
  • Refer to the Academic Writing Expectations for 2000/3000-Level Courses as you compose your Assignment.

By Day 7 Submit your completed Financial Statement Excel Template along with your business report that addresses the following prompts. Part 1: Preparing a Balance Sheet

  • Using the Financial Statement Excel Template, which includes the needed data, prepare a balance sheet for Medi-Supply. Be sure to use proper Excel formulas to show your work in cells where math is involved to derive the answers.
  • Using the Business Report Template, how would you interpret the quality of the balance sheet? In your response, be sure to address whether there is excessive leverage, enough cash to make payroll and/or buy equipment, et cetera. (75–150 words, or 1–2 paragraphs)
  • Based on your interpretation of the balance sheet, would you recommend lending to the company? Explain why or why not, including any potential risks. (75–150 words, or 1–2 paragraphs)

Part 2: Building an Income Statement

  • Using the Financial Statement Excel Template, which includes the needed data, prepare an income statement for Medi-Supply. Be sure to use proper Excel formulas to show your work in cells where math is involved to derive the answers.
  • Using the Business Report Template, address the following using Medi-Supply’s income statement:
  • Interpret the quality of the income statement for this company. Is the income statement improving or deteriorating over time? Explain your answer, including why you reached your conclusion. (75–150 words, or 1–2 paragraphs)
  • Describe whether or not this company is profitable. If the company is unprofitable, explain if it is growing fast enough for sales to outpace expenses. (75 words, or 1 paragraph)
  • Based on their income statement, would you invest in the company? (75 words, or 1 paragraph)

Part 3: Calculating the Operating Cash Flow

  • Using the Financial Statement Excel Template, which includes the needed data, compute the operating cash flow for Medi-Supply. Be sure to use proper Excel formulas to show your work in cells where math is involved to derive the answers.
  • Using the Business Report Template, address the following using Medi-Supply’s operating cash flow:
  • Interpret the quality of the operating cash flow for this company. Is the operating cash flow improving or deteriorating over time? Explain your answer, as well as why you reached your conclusion. (75–150 words, or 1–2 paragraphs)
  • Describe whether or not the company generates positive cash flow from operations. (75 words, or 1 paragraph)
  • Based on the quality of their cash flow, would you invest in the company? (75 words, or 1 paragraph)

Note: For each part of your business report, be sure to reference at least one scholarly source to support your findings, for a total of three (3) scholarly sources. Use the Week 2 Assignment Business Report Template and the Week 2 Assignment Financial Statement Excel Template, provided in this week’s Learning Resources, to complete this Assignment.

  • 5 years ago
  • 8
  • SLP and Case
  • (for Expert_Researcher)
  • For Nyanya only, here is the other assignment thanks.
  • for armodrillo1 only
  • Business Theory
  • 52 - KW
  • OSHA-List and discuss five important criteria that a state must meet in order to be approved by OSHA for safety and health related responsibility.
  • I am not understanding my homework assignment? NOTE: Your Unit I Assignment/Assessment Instructions are located in your course "Syllabus/Schedule." The Unit I...
  • 2 Ethics IP
  • Essay Series - Extended Opinion Piece
1,268views
4.4
(245 ratings)

Related Study Guides

FAC1502 Assignment 7 2024 (Whatspp 0.7.6.9.2.3.4.4.2.23) - Financial Accounting (FAC1502) - Stuvia US

5. Assessment 4 Assessment 4 Opened: Tuesday, 14 May 2024, 8:00 AM Closes: Tuesday, 21 May 2024, 11:00 PM 218909 Attempts allowed: 1 Time limit: 2 hours Grade to pass: 50.00 out of 100.00 Summary of y...

financeaccounting

Programming Questions & Answers | Solutioninn.com

8. Area of Triangle You are given 3 sets of coordinates that form a triangle. Write code to find the area of the triangle enclosed by those coordinates. For example, the 3 points have coordinates... T...

art-designstatistics

Finance Questions & Answers | Solutioninn.com

1. Do you think a country the size of Iceland a Lilliputian is more or less sensitive to the potential impacts of global capital movements? 2. Many countries have used interest rate increases to... Gi...

art-designfinance

rasmussen MA278/BSC2346 Module 5 midterm 2019 latest 100% graded

- Question 1 1 out of 1 points Wolff’s law of bone states that bone density is directly related to the dietary ingestion of calcium. True False - Question 2 1 out of 1 points Which statement is true r...

art-designbiology

General management Questions & Answers | Solutioninn.com

1) Does Mrs. Murphy have a formation defense for the business contract? 2) Does Mrs. Murphy have an enforcement defense for the real estate contract? You are a junior associate at a top law firm in......

art-designmarketing

[SOLVED] Imagine that you are Magna's new corporate controller and answer the | SolutionInn

Question: Imagine that you are Magna's new corporate controller and answer the following: 1. Describe Magna's strategy in terms of how it competes for customers. Imagine that you are Magna's new corpo...

financeart-design

[SOLVED] Apollo Shoes is an audit case designed to introduce you to | SolutionInn

5) Identify at least one relevant assertion for each of the significant accounts or disclosures previously identified from the financial statements of Apollo Shoes. What makes each assertion relevant?...

statisticsfinance

[SOLVED] Ann is a recent engineering graduate with two years experience in | SolutionInn

Question: Ann is a recent engineering graduate with two years experience in her current role and is currently looking at getting a Masters degree. She is Ann is a recent engineering graduate with two...

financeengineering

Need Help With A Similar Question?

Our experts deliver perfect solutions with guaranteed A+ grades

A+
Student Grade
98%
Success Rate
12h
Delivery Time
Join 1,000+ students who got their perfect solutions
Rated 4.9/5 by satisfied students

Need Help With This Question?

Academic Expert

Subject Matter Specialist

98%
Success Rate
24/7
Support

Why Students Trust Us

  • PhD-Level Expertise
  • Original Work Guarantee
  • Better Grade or Free

"Got an A+ on my assignment. Exactly what I needed!"

Recent Student