Compute the ratios listed with the income statement

Reference no: EM132478173 , Length: Word count: 2000

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:

Question 1. Write a synopsis of the company.

Question 2. Discuss the loan amount and how you plan to use the loan proceeds.

Question 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.

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

Reference no: EM132478173

Questions Cloud

We all know that mortgages have risk : We all know that mortgages have risk. Discuss those risks and give examples to illustrate your point.

Calculate the firm net income : Garden Pro Corporation has sales of $4,651,440; income tax of $397,562; the selling, general and administrative expenses of $228,360; depreciation of $360,279

Pairing-Free CP-ABE Based on Elliptic Curve : Pairing-Free CP-ABE Based on Elliptic Curve for Electronic Health Records System and Implement the CP-ABE scheme based on the elliptic curve integrated

Compute the depreciation expense to be recognized : Compute the depreciation expense to be recognized each calendar year for financial reporting purposes under the 200 percent declining-balance method

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

Calculate the firm net income : Garden Pro Corporation has sales of $4,651,440; income tax of $397,562; the selling, general and administrative expenses of $228,360; depreciation of $360,279

Estimate the wacc for a firm whose asset : You need to estimate the WACC for a firm whose asset (unlevered) beta is 1. The firm will be 50% debt financed and its cost of debt

Are americans becoming ruder in interaction with one another : Are Americans becoming ruder in their interactions with one another in the business environment? Explain and document your reasoning using scholarly

Which option is the least costly to the company : Location A may be purchased for $525000. Location B may be acquired with a down payment of $105000. Which option is the least costly to the company

User Account

All Pages