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 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)
Requirements: 2-3 pages
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.
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 moreEach 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 moreThanks 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 moreYour 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 moreBy 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