Purchase Solution

Calculating Ratios; Report to the President

Not what you're looking for?

Ask Custom Question

To better understand the past two years, the president asks you to create a financial income statement and balance sheet for AFC for the combined years of 2004 and 2005. Use this information to calculate the following ratios:

net margin
return on investment
return on equity

Write a letter to the president analyzing and comparing these ratios year to year. Point out which ones have improved the most and why.

The balance sheet and income statements are attached. There are also some templates that the instructor provided as guidance.

Purchase this Solution

Solution Summary

The solution shows the ratio calculations in detail. The letter to the President explains the purpose for the ratio analysis and discloses some problems which become apparent with the ratio comparisons.

Solution Preview

Ratio calculations:

ROI for 2004 = NI/ TA = 120565/220565 = 54.7%
ROI for 2005 = NI/TA = 95200/298565 = 47.9%

Net Margin for 2004 = NI/ Net sales = 120565/350,000 = 34.4%
Net Margin for 2005 = NI/Net sales = 95200/450,000 = 21.1%

ROE for 2004 is the same as ROI
ROE for 2005 is the same as ROI

It is a curious situation that ROI and ROE would be identical, but it is explainable. With no debt of any kind, assets = equities. With debt, the ratios would not be same because total assets would not be the same as total stockholders' equity.

To the President

I have completed the financial statements including the income statement and the balance sheets on a comparative basis from 2005 to ...

Purchase this Solution


Free BrainMass Quizzes
Business Ethics Awareness Strategy

This quiz is designed to assess your current ability for determining the characteristics of ethical behavior. It is essential that leaders, managers, and employees are able to distinguish between positive and negative ethical behavior. The quicker you assess a person's ethical tendency, the awareness empowers you to develop a strategy on how to interact with them.

Marketing Management Philosophies Quiz

A test on how well a student understands the basic assumptions of marketers on buyers that will form a basis of their marketing strategies.

Writing Business Plans

This quiz will test your understanding of how to write good business plans, the usual components of a good plan, purposes, terms, and writing style tips.

Lean your Process

This quiz will help you understand the basic concepts of Lean.

Managing the Older Worker

This quiz will let you know some of the basics of dealing with older workers. This is increasingly important for managers and human resource workers as many countries are facing an increase in older people in the workforce