FIN 425 Homework #1 Part 1 Using Sheet1 of Excel, create a one year quarterly operating budget for ABC Manufacturing Corporation based on the following assumptions. Place all of the assumptions at the top of the spreadsheet, not within the statement. (All quarterly changes are compounded). It is projected that sales for the first quarter will be 10,000 units. After the first quarter, it is projected that sales will increase by 500 units per quarter. The selling price of each unit for the first quarter will be $150. After the first quarter, the selling price will increase by 3% per quarter. The cost of goods sold is projected to be $58 per unit for the first quarter. After the first quarter, the cost of goods sold per unit is projected to increase by 2% per quarter. Rent is projected to be $10,000 per quarter. Rent is projected to increase 1% each quarter. Utility expense is projected to be $15,000 for the first quarter. After the first quarter, it is expected to increase 6% per quarter. General overhead is projected to be $15,000 for the first quarter. After the first quarter, general overhead will increase by 4% per quarter. Advertising is projected to be $8,000 for the first quarter. After the first quarter, advertising will DECREASE by 2% per quarter. Interest expense is projected to be $1,000 per quarter. The tax rate is estimated to be 45% of taxable income. It is projected that dividends will be $2,000 per quarter. Copy your quarterly operating budget to Sheet2, Sheet3, and Sheet4. Part 2 - Sheet2 Adjust the spreadsheet in Sheet2 to accommodate the following changes: It is now projected that sales for the first quarter will be 12,000 units. After the first quarter, it is projected that sales will increase by 700 units per quarter Part 3 - Sheet3 Adjust the spreadsheet in Sheet3 to accommodate the following changes: The selling price of each unit for the first quarter is now projected to be $175. After the first quarter, the selling price will increase by 7% per quarter. Part 4 - Sheet4 Adjust the spreadsheet in Sheet4 to accommodate the following changes: The dividends are projected to be $2,500 for the first quarter. After the first quarter, it is projected that the dividends will increase by 20% per quarter