A company is projecting a cost of goods of 52% of the selling price of its products. It has $280,000 in fixed overhead for administrative expenses, rent and salaries. In addition, it spends 22% of every sales dollar on marketing. The Break-even point is $1076923.08. In order to start the business the owner has found an investor who will put up $500,000. The owner wants to pay back the investor out of profits, using 30% of the pre-tax profits to pay the investor, and he has guaranteed the investor he will get back $750,000.

How long will it take to pay the investor $750,000, if sales in year one are $2 million, and sales increase 13% each year. (Assume fixed expenses will increase each year at the rate of infllation or about 4%). Show your calculations in a spreadsheet.