Use the model developed in the excel spreadsheet to answer

Assignment Help Financial Management

Reference no: EM13381546

Use the model developed in the Excel spreadsheet to answer the following questions:

1. What is the EFN to achieve the projected 50% growth rate (change the Notes Payable, Long-term debt, and common equity to make the balance sheet balanced)?

2. In your financial forecast, what would happen to the EFN, if the dividend payout ratio were increased to 35%? Provide the numerical answer. In addition to the numerical answer, try to explain it from the interaction involving the different variables on the income statement and the balance sheet.

3. If the firm is reluctant to use additional external financing due to the tight credit market and equity market, what is the maximum growth rate in sales that you forecast for the firm? Assume that the firm do not want to increase its financial risk (i.e. current ratio>=2.6 and debt ratio<=0.43). As a financial consultant, what is your advice on its dividend payout policy, if the firm wants to achieve a higher growth rate? Support your advice in light of your answer to the question above.

Attachment:- Financial-Forecasting-Homework.pdf

Reference no: EM13381546

Questions Cloud

Qrefer to the financial statements of quaker oats company : qrefer to the financial statements of quaker oats company. prepare a forecasted income statement for year 12 using

Q1a calculate return on common equity for year 9 using : q1a. calculate return on common equity for year 9 using year-end amounts and assuming no preferred dividends.b.

Quaker oats in its annual report discloses the quaker oats : quaker oats in its annual report discloses the quaker oats company followingfinancial objectives provide total

A colleague who is aware of your understanding of financial : a colleague who is aware of your understanding of financial statements asks for help in analyzing the transactions and

Use the model developed in the excel spreadsheet to answer : use the model developed in the excel spreadsheet to answer the following questions1. what is the efn to achieve the

Discuss the following topic does arbitrage destabilize : discuss the following topic does arbitrage destabilize foreign exchange markets? arbitrage can be loosely defined as

Question 1 the following table shows monthly closing prices : question 1 the following table shows monthly closing prices in dollars for four of australias major stocks. these

Sunny hotels plc owns a successful chain of hotels the : sunny hotels plc owns a successful chain of hotels. the company is considering diversifying its activities through the

Jason approaches allinsurance for insurance over the house : jason approaches allinsurance for insurance over the house he is renting. he lives in the house but his partner is

User Account

All Pages