Question: Forecasting Report Assignment Introduction You have been tasked with preparing and presenting a five-year forecast to upper management. Select a publicly traded retailer, I chose

Forecasting Report Assignment Introduction You have been tasked with preparing and presenting a five-year forecast to upper management. Select a publicly traded retailer, I chose Walmart Inc. with at least the last three years of publicly available financial statements. Use those financial statements and the assumptions listed below. If further assumptions need to be made, make reasonable assumptions and document the assumption and your logic within the report. Task Your deliverable will be a Forecasting Report providing upper management with a 5-year balance sheet forecast and income statement. You have been reminded that executives are extremely busy; therefore, you must keep the executive Summary that shall accompany your schedules to a maximum of two pages. Income Statement Forecast Assumptions: Sales: Assume sales will grow 4.0% yearly from Year +1 to Year +5. Cost of Goods Sold: Assume that the cost of goods sold to sales percentage will be 75.0% for Year +1 to Year +5. Selling and Administrative Expenses: Assume that the selling and administrative expenses will average 19.0% of sales for Year +1 to Year +5. Interest Income: Assume the Company will earn interest income based on a 2.6% interest rate on average cash balances (that is, the sum of beginning and end-of-year cash balances divided by 2) for Year +1 through Year +5. PLEASE WAIT FOR MORE

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

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

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Accounting Questions!