Business Finance Homework Help

Rasmussen College Financial Statement Analysis Excel Task

 

  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:
  2. Identify and explain three horizontal analysis items that are not 0%.
  3. Identify and explain three vertical analysis items that are not 0%.
  4. 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?
  5. 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:
  6. Identify and explain three horizontal analysis items that are not 0%.
  7. Identify and explain three vertical analysis items that are not 0%.
  8. Do you think the short timeframe being measured here impacts the reliability of your analysis? Why or why not?
  9. Using Microsoft Excel formulas, calculate the following ratios for QB Cloud and interpret the results:
  10. Debt Ratio (Total Liabilities/Total Assets)
  11. Current Ratio (Current Assets/Current Liabilities)
  12. Profit Margin (Net Income/Sales)