Question: Start with the partial model in the file Ch09 P10 Build a Model.xlsx on the textbook's Web site, which contains the 2015 financial statements of

Start with the partial model in the file Ch09 P10 Build a Model.xlsx on the textbook's Web site, which contains the 2015 financial statements of Zieber Corporation. Forecast Zeiber's 2016 income statement and balance sheets. Use the following assumptions:

(1) Sales grow by 6%.

(2) The ratios of expenses to sales, depreciation to fixed assets, cash to sales, accounts receivable to sales, and inventories to sales will be the same in 2016 as in 2015.

(3) Zeiber will not issue any new stock or new long-term bonds.

(4) The interest rate is 11% for long-term debt and the interest expense on long-term debt is based on the average balance during the year.

(5) No interest is earned on cash.

(6) Regular dividends grow at an 8% rate. Calculate the additional funds needed (AFN). If new financing is required, assume it will be raised by drawing on a line of credit with an interest rate of 12%. Assume that any draw on the line of credit will be made on the last day of the year, so there will be no additional interest expense for the new line of credit. If surplus funds are available, pay a special dividend.

a. What are the forecasted levels of the line of credit and special dividends?

b. Now assume that the growth in sales is only 3%. What are the forecasted levels of the line of credit and special dividends?

Step by Step Solution

★★★★★

3.59 Rating (152 Votes )

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock

Key Input Data Used in the forecast Tax rate 40 Dividend growth rate 8 Rate on notes payableterm debt r std 9 Rate on longterm debt r d 11 Rate on line of credit r LOC 12 Begin by calculating the appr... View full answer

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Document Format (1 attachment)

1069-B-F-F-M(8089).xlsx

300 KBs Excel File

Students Have Also Explored These Related Finance Questions!

Start with the partial model in the file Ch09 P11 Build a Model.xlsx on the textbook's Web site, which contains Henley Corporation's most recent financial statements. Use the following ratios and...

Start with the partial model in the file Ch06 P15 Build a Model.xlsx on the textbook's Web site. The file contains hypothetical data for working this problem. Goodman Corporation's and Landry...

Start with the partial model in the file Ch04 P35 Build a Model.xlsx from the textbook's Web site. Answer the following questions, using the spreadsheet model to do the calculations. a. Find the FV...

Start with the partial model in the file Ch09 P10 Build a Model.xls x on the textbook's Web site, which contains the 2018 financial statements of Zieber Corporation. Forecast Zeiber's 2019 income...

Start with the partial model in the file Ch09 P10 Build a Model.xls x on the textbook's Web site, which contains the 2018 financial statements of Zeiber Corporation. Forecast Zeiber's 2019 income...

12-12 Start with the partial model in the file Ch12 P10 Build a Model.xls on the textbook s Web site, which contains the 2013 financial statements of Zieber Corporation. Forecast Zeiber s 2014 income...

Start with the partial model in the file Ch12 P10 Build a Model.xlsx on the text book's Web site, which contains the 2016 financial statements of Zieber Corporation. Forecast Zieber's 2017 income...

Start with the partial model in the file Ch 1 2 P 1 0 Build a Model.xls x on the textbook's Web site, which contains the After completing the preliminary forecast of the balance sheets and income...

Build a Model Problem Start with the partial model in the file Ch 1 2 P 1 0 Build a Model.xls x on the textbook's Web site, which contains the 2 0 2 3 financial statements of Zieber Corporation....

Start with the partial model in the file Ch 1 2 P 1 0 Build a Model.xlsx on the textbook s Web site, which contains the 2 0 2 3 financial statements of Zieber Corporation. Forecast Zeiber's 2 0 2 4...

Populations grow larger from births and immigration and grow smaller from deaths and emigration. The growth rate for a population is determined by adding the birth rate and the immigration rate, and...

Mel Finney believes actual manufacturing overhead should be charged to jobs. Do you agree? Why or why not?

Operating Margin is calculated by the following formula A . Cash & Cash Equivalents / ( Cash Expenses / 3 6 5 days ) B . Net Patient Receivables / ( Net Patient Service Revenue / 3 6 5 days ) C ....

Define opportunity cost. What is your opportunity cost of attending a class at 11:00 ..? How does it differ from your opportunity cost of attending a class at 8:00 ..?

The following inventory data have been established for the Adler Corporation. (1) Orders must be placed in multiples of 100 units. (2) Annual sales are 338,000 units. (3) The purchase price per unit...

Start with the partial model in the file Ch24 P06 Build a Model.xls on the textbook's Web site. Use the information and data below. F. Pierce Products Inc. is financing a new manufacturing facility...

Start with the partial model in the file Ch25 P05 Build a Model.xls on the textbook's Web site. Duchon Industries had the following balance sheet at the time it defaulted on its interest payments and...

Bill Clinton reportedly was paid $15.0 million to write his book My Life. The book took three years to write. In the time he spent writing, Clinton could have been paid to make speeches. Given his...

with steps please Question 3 (45 marks) The vapor-liquid equilibrium data for a binary liquid solution containing methanol (1) - methyl acetate (2) at 101.3 kPa is given in Table 2. Assume that the...

What is the after-tax discount rate? ANSWER: What is the present value of the after-tax net returns? ANSWER: What is the present value tax savings from depreciation? ANSWER: What is the present value...