Interpreting financial statements | FNCE 3001 – Financial Management | Walden University

 

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.

Calculate the price of your order

550 words
We'll send you the first draft for approval by September 11, 2018 at 10:52 AM
Total price:
$26
The price is based on these factors:
Academic level
Number of pages
Urgency
Basic features
  • Free title page and bibliography
  • Unlimited revisions
  • Plagiarism-free guarantee
  • Money-back guarantee
  • 24/7 support
On-demand options
  • Writer’s samples
  • Part-by-part delivery
  • Overnight delivery
  • Copies of used sources
  • Expert Proofreading
Paper format
  • 275 words per page
  • 12 pt Arial/Times New Roman
  • Double line spacing
  • Any citation style (APA, MLA, Chicago/Turabian, Harvard)

Our guarantees

Delivering a high-quality product at a reasonable price is not enough anymore.
That’s why we have developed 5 beneficial guarantees that will make your experience with our service enjoyable, easy, and safe.

Money-back guarantee

You have to be 100% sure of the quality of your product to give a money-back guarantee. This describes us perfectly. Make sure that this guarantee is totally transparent.

Read more

Zero-plagiarism guarantee

Each paper is composed from scratch, according to your instructions. It is then checked by our plagiarism-detection software. There is no gap where plagiarism could squeeze in.

Read more

Free-revision policy

Thanks to our free revisions, there is no way for you to be unsatisfied. We will work on your paper until you are completely happy with the result.

Read more

Privacy policy

Your email is safe, as we store it according to international data protection rules. Your bank details are secure, as we use only reliable payment systems.

Read more

Fair-cooperation guarantee

By sending us your money, you buy the service we provide. Check out our terms and conditions if you prefer business talks to be laid out in official language.

Read more

STAY HOME, SAVE LIVES. Order your essay today and save 20% with the discount code ATOM