Reference no: EM132453094

Problem - From the following information, prepare a financial model that would produce budgeted income statements and statements of retained earnings for the 5 years 20X2 to 20X6 for Unique Traders Ltd.

All necessary calculations should be performed by the computer.

Unique trades in one product only. In 20X1 sales were 30 000 units and volume is expected to increase by 8% each year (compound) to a maximum of 40 000 units per year.

Unit selling price in the years 20X2, 20X3, 20X4 is expected to equal the unit cost of purchases made in the year, marked up by 30% whilst in 20X5 and 20X6 the mark-up is expected to be 35% on purchase cost.

Unit purchase costs for the 5 years are estimated at 20X2 $5.10, 20X3 $5.36, 20X4 $5.68, 20X5 $6.02, 20X6 $6.50.

Closing inventory is to be 15% of estimated sales units for the following year. Closing inventory for 20X1, however, was only 3600 units valued at $17 640. Assume a FIFO cost flow.

General and administrative expenses are expected to equal 14% of sales revenue in each year.

The tax rate is expected to be 40%.

Provide for dividends equal to 65% of after tax profit.

Retained earnings at the end of 20X1 amounted to $3500.