ownload EE Home Assignment 1 - Basic EE Functions.docx (15.5 KB Pages 1 > of o ZOOM + Week 1 and Week 2 Home Assignment 1. This assignment contains FIVE Problems. 2. All the problem must be complete with MS Excel (not using MS Excel will result Zero grade). 3. Show your work for full credit. 4. Submit your work before due date Problem 1 - 10 points The annual income for Company A is $360,000 in year 1 and it decreased by $15,000 each year. Interest rate is 10% per year. 1. What is the income in year 3? 2. What is the present worth of the incomes in year 0? 3. What is the future worth of the incomes in yea5? 4. What was the equivalent annual worth of the comes through year ? Problem 2-10 points Company B is expecting a total sale to be 5 million in the first year and will increase by 10% each year for the next 5 years. The company will set aside 2% of its' total sales for year-end employee bonuses. Interest rate is 8% per year. What is the equivalent annual worth in year 1 through year 5 of the bonus package? Problem 3-10 points Determine the present worth in year of the following cost. Interest rate is 10% per year. Cost ($10001 0 850 -300 Year 1 Previous Next 16 O tv MacBook Pro G Search or type URL & # 3 $ 4 % 5 6 7 8