Business Plan

 

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.