80.2K

Verified Solution

Link Copied!

please answer ASAP and show work on to get the forecasts

Key Input Data: Tax rate Owidend growth rate Rate on notes payable-term debt, r3 Rate on longterm debt, td Rate on line of eredic r10 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 doesnt include any new line of eredit er special dividends. Idently the finaneing deficit or surplus in this preliminary forecast and then add a new column that ohows the Enal forecast that includes any new line of credit or apecial dividend.) Forecast the peliminary balance sheets and income statements in Column H. Dont include any line of credit er speclal dividend in the preliminary forecast Aher completing the preliminary forecast of the balance sheets and income statement, go to the area below the preliminary forecast and identify the financing deficit or surplus. Then use Excel's if statements to specify the amount of any new line of credit OR special dividend fyou should not have a new line of credit AvD a special dividend, enly one or the other). After specifying the amounts of the special dividend or line of credit, create a second column (0) for the final forecast next to the column for the preliminary focecast 0 ?. In this final forecast, be sure to include the effect of the special dividend or line of credie. Income Statements: (December 31, in thousands of dollars) Sales Expenses (excluding depr, 8 amort) Depreclation and Amortization EDI Imerest expense on longterm debt Interest expense on line of credit Key Input Data: Tax rate Owidend growth rate Rate on notes payable-term debt, r3 Rate on longterm debt, td Rate on line of eredic r10 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 doesnt include any new line of eredit er special dividends. Idently the finaneing deficit or surplus in this preliminary forecast and then add a new column that ohows the Enal forecast that includes any new line of credit or apecial dividend.) Forecast the peliminary balance sheets and income statements in Column H. Dont include any line of credit er speclal dividend in the preliminary forecast Aher completing the preliminary forecast of the balance sheets and income statement, go to the area below the preliminary forecast and identify the financing deficit or surplus. Then use Excel's if statements to specify the amount of any new line of credit OR special dividend fyou should not have a new line of credit AvD a special dividend, enly one or the other). After specifying the amounts of the special dividend or line of credit, create a second column (0) for the final forecast next to the column for the preliminary focecast 0 ?. In this final forecast, be sure to include the effect of the special dividend or line of credie. Income Statements: (December 31, in thousands of dollars) Sales Expenses (excluding depr, 8 amort) Depreclation and Amortization EDI Imerest expense on longterm debt Interest expense on line of credit

Answer & Explanation Solved by verified expert

See Answer