International House Corporation (IHC) began operations this year. The company retains property losses and estimates that property losses will be $260,000 this year. Property losses are expected to increase by 25 percent per year for the next two years. Use the Excel future value function to find the losses in year 2 and year 3. IHC expects to pay 92 percent of property losses in the year the loss occurs, with 8 percent paid in the following year. How much in retained property losses is IHC expected to pay this year and in each of the next two years? SHOW ALL WORK IN EXCEL

1. Calculate the losses and retained property losses for each year

Growth Rate Losses in Year 1 Losses in Year 2 Losses in Year 3 $250,000.00 Retained Losses in Year 1 Retained Losses in Year 2 Retained Losses in Year 3