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.