Rasmussen Mod 4 Ratio Analysis and Balance Sheet of the QB Cloud Worksheet

As the fiscal year ends for a company, it is important to analyze how the company is performing to determine if there are issues to work on and successes to expand on.

As the owner of QB Cloud, you’re interested in finding out how well the company has done in the first three months of operations. Complete the following tasks using the Module 04 Analysis template

1. Using Microsoft Excel formulas, calculate a horizontal and vertical analysis for the first three months of QB Cloud’s operations for the profit and loss. Address the following questions:
   1. Identify and explain three horizontal analysis items that are not 0%.
   2. Identify and explain three vertical analysis items that are not 0%.
   3. Which expenses seem to be appropriated only to certain months? Do you believe this is the correct application or should they be appropriated differently? Why or why not?
2. Using Microsoft Excel formulas, calculate a horizontal and vertical analysis for the first three months of QB Cloud’s operations for the balance sheet. Address the following questions:
   1. Identify and explain three horizontal analysis items that are not 0%.
   2. Identify and explain three vertical analysis items that are not 0%.
   3. Do you think the short timeframe being measured here impacts the reliability of your analysis? Why or why not?
3. Using Microsoft Excel formulas, calculate the following ratios for QB Cloud and interpret the results:
   1. Debt Ratio (Total Liabilities/Total Assets)
   2. Current Ratio (Current Assets/Current Liabilities)
   3. Profit Margin (Net Income/Sales)

If you need a refresher on Microsoft Excel, check out the Excel for Accounting Guide