# “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 Corporation. Forecast Zieber’s 2020 income stat

“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 Corporation. Forecast Zieber’s 2020 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, ac-counts receivable to sales, and inventories to sales will be the same in 2020 as in 2019. (3) Zieber 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. (7) The tax rate is 25%. resourceCalculate 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? (Hints: Create a column showing the ratios for the current year; then create a new column showing the ratios used in the forecast. Also, create a preliminary forecast that doesn’t include any new line of credit or special dividends. Identify the financing deficit or surplus in this preliminary forecast and then add a new column that shows the final forecast that includes any new line of credit or special dividend.) (12-11) Build a Model: Forecasting and Valuation533b. Now assume that the growth in sales is only 3%. What are the forecasted levels of the line of credit and special dividends?”

Don't use plagiarized sources. Get Your Custom Essay on
“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 Corporation. Forecast Zieber’s 2020 income stat
Just from \$13/Page

## Calculate the price of your order

550 words
We'll send you the first draft for approval by September 11, 2018 at 10:52 AM
Total price:
\$26
The price is based on these factors:
Number of pages
Urgency
Basic features
• Free title page and bibliography
• Unlimited revisions
• Plagiarism-free guarantee
• Money-back guarantee
On-demand options
• Writer’s samples
• Part-by-part delivery
• Overnight delivery
• Copies of used sources
Paper format
• 275 words per page
• 12 pt Arial/Times New Roman
• Double line spacing
• Any citation style (APA, MLA, Chicago/Turabian, Harvard)

# Our guarantees

Delivering a high-quality product at a reasonable price is not enough anymore.
That’s why we have developed 5 beneficial guarantees that will make your experience with our service enjoyable, easy, and safe.

### Money-back guarantee

You have to be 100% sure of the quality of your product to give a money-back guarantee. This describes us perfectly. Make sure that this guarantee is totally transparent.

### Zero-plagiarism guarantee

Each paper is composed from scratch, according to your instructions. It is then checked by our plagiarism-detection software. There is no gap where plagiarism could squeeze in.

### Free-revision policy

Thanks to our free revisions, there is no way for you to be unsatisfied. We will work on your paper until you are completely happy with the result.