Compute the ratios listed with the balance sheet

Assignment Help Accounting Basics
Reference no: EM132565155 , Length: Word: 2000

Prepare an analysis of the assigned company (1500 - 2,000 words) in order to secure a loan for the company. The loan will increase the company's total liabilities by 3%. The contents of the project include the following:

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

Question 2. Use the Excel Spreadsheet provided and complete the following.

a. Prepare a five year vertical analysis of the company's income statement.
b. Prepare a projected income statement for 2020 and 2021 assuming sales increase by 3% and 6%.
c. Compute the ratios listed with the income statement.
d. Compute the ratios listed with the balance sheet.

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

Attachment:- loan proceed.zip

Reference no: EM132565155

Questions Cloud

Explain how is possible with natural selection occurring : 1. Harmful alleles persist in some populations, explain how this is possible with natural selection occurring?
Explain each of the three elements of cvp analysis : Explain each of the three elements of CVP analysis. Discuss how managers use CVP analysis. how changes in costs and volume affect their operating expense
Determine the speculator profit if the yen appreciates : Diagram the call option, profit (or loss) on the y-axis and future spot price on the x-axis. Determine the speculator's profit if the yen appreciates
Have you personally witnessed a crisis in your organization : Have you personally witnessed a crisis in your organization? How can managers ensure organizational character during a crisis?
Compute the ratios listed with the balance sheet : Compute the ratios listed with the balance sheet. Prepare a projected income statement for 2020 and 2021 assuming sales increase by 3% and 6%.
What is the importance of electrons in transfer of energy : What is the importance of electrons in the transfer of energy in living systems, and what is an example?
List three advantages of either polymerase chain : Question: List three advantages of either polymerase chain reaction or gene cloning over the other.
Compute the annual depreciation for each of the five years : Compute the annual depreciation for each of the five years under each of the following methods: units-of-activity and straight-line
What is impact of engaged versus disengaged employees : What is the impact of "engaged" versus "disengaged" employees on a company's profits? How would you use Drucker's Management by Objectives,

Reviews

Write a Review

Accounting Basics Questions & Answers

  How much control does fed have over this longer real rate

Hubbard argues that the Fed can control the Fed funds rate, but the interest rate that is important for the economy is a longer-term real rate of interest.   How much control does the Fed have over this longer real rate?

  Coures:- fundamental accounting principles

Coures:- Fundamental Accounting Principles: - Explain the goals and uses of special journals.

  Accounting problems

Accounting problems,  Draw a detailed timeline incorporating the dividends, calculate    the exact Payback Period  b)   the discounted Payback Period. the IRR,  the NPV, the Profitability Index.

  Write a report on internal controls

Write a report on Internal Controls

  Prepare the bank reconciliation for company

Prepare the bank reconciliation for company.

  Cost-benefit analysis

Create a cost-benefit analysis to evaluate the project

  Theory of interest

Theory of Interest: NPV, IRR, Nominal and Real, Amortization, Sinking Fund, TWRR, DWRR

  Liquidity and profitability

Distinguish between liquidity and profitability.

  What is the expected risk premium on the portfolio

Your Corp, Inc. has a corporate tax rate of 35%. Please calculate their after tax cost of debt expressed as a percentage. Your Corp, Inc. has several outstanding bond issues all of which require semiannual interest payments.

  Simple interest and compound interest

Simple Interest, Compound interest, discount rate, force of interest, AV, PV

  Capm and venture capital

CAPM and Venture Capital

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd