90.2K

Verified Solution

Link Copied!

i NEED THE FORMULA YOU PUT IN EXCEL TO GET THE ANSWER. NOT JUST THE ANSWER

Here are the instructions for the Income Statement forecast Forecast the Income statement for Yoyodyne Propulsion systems: Total 11pts) 1) Use the TREND function to forecast the new period sales (3 pts) 2) Use Long Term Average Percent of Sales to forecast Cost of Sales and Selling, General & Administration Expenses (2 pts each) 3) In the Assumptions area, calculate Depreciation and Interest Expense. Assume last year's expense plus any change you need to calculate in the Assumptions area. (1 pts each) 4) Assume Other Income, Net as the same as 2013 and Preferred Dividends wi be the same 5) Additional Debt rate will be 12% and Tax Rate is 30% 6) Assume an increase of 10% in Dividends per Common Share over last year. Here are the instructions for the Income Statement forecast Forecast the Income statement for Yoyodyne Propulsion systems: Total 11pts) 1) Use the TREND function to forecast the new period sales (3 pts) 2) Use Long Term Average Percent of Sales to forecast Cost of Sales and Selling, General & Administration Expenses (2 pts each) 3) In the Assumptions area, calculate Depreciation and Interest Expense. Assume last year's expense plus any change you need to calculate in the Assumptions area. (1 pts each) 4) Assume Other Income, Net as the same as 2013 and Preferred Dividends wi be the same 5) Additional Debt rate will be 12% and Tax Rate is 30% 6) Assume an increase of 10% in Dividends per Common Share over last year

Answer & Explanation Solved by verified expert

See Answer