In: Economics
Acme Bricks, a masonry products company, wants to have $600,000 on hand before it invests in new conveyors, trucks and other equipment. If the company sets aside $80,000 per year in an account that increases in value at a rate of 15% per year, how many years will it be before Acne can purchase the equipment?
EXCEL SPREADSHEET ONLY!
We have been given the following information
Company is saving $80,000 per annum
Increase rate = 15% per annum
Amount needed = $600,000
Formula used = Previous Year Amount × (1 + 0.15)
| 
 Year  | 
 Amount Saved  | 
| 
 Year 1  | 
 80,000  | 
| 
 Year 2  | 
 92,000  | 
| 
 Year 3  | 
 105,800  | 
| 
 Year 4  | 
 121,670  | 
| 
 Year 5  | 
 139,921  | 
| 
 Year 6  | 
 160,909  | 
| 
 Year 7  | 
 185,045  | 
| 
 Year 8  | 
 212,802  | 
| 
 Year 9  | 
 244,722  | 
| 
 Year 10  | 
 281,430  | 
| 
 Year 11  | 
 323,645  | 
| 
 Year 12  | 
 372,191  | 
| 
 Year 13  | 
 428,020  | 
| 
 Year 14  | 
 492,223  | 
| 
 Year 15  | 
 566,056  | 
| 
 Year 16  | 
 650,965  |