Accounting homework help. Prepare an analysis of the assigned company (600 – 2,000 words) in order to secure a loan for the company. The loan will increase the company’s total liabilities by 5%. The contents of the plan should include the following:
1. Write a synopsis of the company.
2. Discuss the loan amount and how you plan to use the loan proceeds.
3. Use the Excel Spreadsheet provided and complete the following.

  • Prepare a three year vertical analysis of the company’s income statement.
  • Prepare a projected income statement for 2020 assuming sales increase by 9%.
  • Compute the ratios listed with the income statement.
  • Compute the ratios listed with the balance sheet.

4. Using the results of your spreadsheet, what questions would you ask the CFO of the company? Explain.

Accounting homework help