Question: Start with the partial model in the file Ch12 P10 Build a Model.xlsx on the textbook'sWeb site, which contains the 2016 financial statements of Zieber

Start with the partial model in the file Ch12 P10 Build a Model.xlsx on the textbook'sWeb site, which contains the 2016 financial statements of Zieber Corporation. Forecast Zieber's 2017 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 2017 as in 2016.

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

(4) The interest rate is 11% for longterm 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.42 Rating (161 Votes )

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock

Given data 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 ... 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)

1090-B-C-F-S-V(452).xlsx

300 KBs Excel File

Students Have Also Explored These Related Corporate Finance Questions!

a) b) c) d) Question 1 Explain the concept of "Time Value of Money". Why this is important for engineering economy studies Explain the differences between the following, and show how they are related...

Start with the partial model in the file Ch 05 Build a Model.xlsx from the textbook's website. Cumberland Industries' financial planners must forecast the company's financial results for the corning...

Start with the partial model in the file Ch12 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 Ch12 P10 Build a model.xlsx on the textbook website, which contains the 2016 financial statements of Zeiber Corporation. Forecast Zieber's 2017 income...

3 Problem: 10 Start with the partial model in the file Ch12 P10 Build a Model.xlsx on the textbook's Website, which contains the 2019 financial statements of Zieber Corporation. Forecast Zeiber's...

3 Merge & Center B1 fx B C D E G H 4 5 Start with the partial model in the file Ch12 P10 Build a Model.xlsx on the textbook's Web site, which contains the 2019 financial statements of Zieber...

= = = Merge & Center $ % 8-98 16 B D 5 Start with the partial model in the file Ch12 P10 Build a Model.xlsx on the textbook's Web site, which contains the 2019 financial statements of Zleber...

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

A O Search AutoSave On File Home S Draw 8 Page Layout ssignment (1) - Read-Only - Excel Formulas Data Review View ins Help 10 A Percentage RX Cut th copy Format Pain Clipboard A A 23 Wrap Text Merge...

Please show the formulas to solve in excel please show how to solve using excel --please provide formulas Start with the partial model in the file Ch12 P10 Build a Model.xlsx on the textbook's Web...

Bill and Hillary confront the same market prices for health care and hamburgers. Bills optimal consumption point is a corner equilibrium where he consumes only hamburgers; Hillarys optimal point...

sinz 55 Given: Sin 35+ sin2 s To find:- Solve

If n = 400 and X = 25, construct a 99% confidence interval estimate for the population proportion.

Westerners are comparatively rare in countries such as Japan. Is it right to portray them in this way? Explain why or why not. (AACSB: Communication; Reflective Thinking; Ethical Reasoning)

a. Set up an amortization schedule for a $25,000 loan to be repaid in equal installments at the end of each of the next 5 years. The interest rate is 10%. b. How large must each annual payment be if...

Sales for Hanebury Corporations just-ended year were $12 million. Sales were $6 million 5 years earlier. a. At what rate did sales grow? b. Suppose someone calculated the sales growth for Hanebury in...

Washington-Pacific invested $4 million to buy a tract of land and plant some young pine trees. The trees can be harvested in 10 years, at which time W-P plans to sell the forest at an expected price...

- Describe at least three ways a for-profit healthcare firm can increase equity . Include brief examples of each. Use the following information to answer questions 3, 4, and 5: 2- You have been asked...

Balance sheet preparation Use the appropriate items from the following list to prepare in good form Mellarks Baked Goods balance sheet at December 31, 2015. Value ($000) at Value ($000) at Item...

b b. calculate the NPV and decide if the system is worth noting the date of retum month Indicated by a minus sign. Do not round Intermediate calculations. Round your new 2 Net procent value Worth...