Salaguay Inc. is a new venture that purchases energy-saving devices in bulk, repackages them, and sell them

Fantastic news! We've Found the answer you've been seeking!

Question:

Salaguay Inc. is a new venture that purchases energy-saving devices in bulk, repackages them, and sell them and installs them to consumers. Its products consist of shower nozzles that restrict the flow of water, thermostats with timers, and storm windows. The company’s management team is preparing forecasted financial statements for the next 5 years (on a yearly basis). Its preliminary budget figures, by product, are shown below:

Forecasted Year 1 Figures

	Shower Nozzles	Thermostats	Storm Windows
Number of Items	800	200	500
Sales price per item	$40	$80	$200
Purchase cost per item	$20	$30	$92
Labor (for repackaging)	$15,000	$4,000	$25,000
Repackaging Materials	$1	$2	$5

The new firm has an overall overhead cost (general and administrative expenses) of $33 K a year. The management team estimates that this same number of overhead cost should be able to support the new venture’s ambitious expansion. The company pays employees to repackage and installing the items strictly on the same hourly basis. The startup’s management team expects unit sales to increase each year by 30%, 25% and 20% for shower, thermostats with timers, and storm windows, respectively. The new firm buys its items on 90-day credit, and bills its customers in cash. The company bought packaging machines for a total $30 k with a loan from a local bank that charges 5% annual interest on the remaining balance. The packing machines are expected to have an economic life of 7 years. The loan is to be repaid in 5 years. All expenses will grow at the expected annual inflation rate of 1.2%.

Salaguay Inc. has hired you to prepare a forecasted income statement, balance sheet and a cash budget for the next 5 years (on a yearly basis). Individually, prepare the required forecasts. You can assume the tax rate is 20% on profits, which are paid in cash in the year that they are incurred. The new venture is to start operations with an initial cash balance of $1 k provided by the 3 owners, in equal parts. The company carries 2 months-worth of finished goods inventory as a buffer against sudden surges in demand. The company wants to keep a minimum cash balance of 1 moth worth of overhead cost.