Project Problem One:
Please find attached the 2017 financial statements for Aquatic Supplies Co.
Also appearing are management’s forecasts for how individual financial statement items will vary in the future.
The company expects sales to grow 12% next year.
Aquatic Supplies finances all of its needs with 10-year long-term debt at 10% interest.
a. Prepare pro forma financial statements sensitivity analysis for Aquatic Supplies for 2018 assuming that long-term debt and interest expense remain at their 2017 levels.
What is Aquatic’s external funding required for 2018?
b. Modify your forecast in part (a) assuming that long-term debt and interest expense increase in order to make up the external funding required for 2018.
How much additional long-term debt will be required under this assumption?
c. Why are your answers to part (a) and part (b) different?
d. Perform a sensitivity analysis of Aquatic Supplies Co.’s external financing needs as determined in part (b).
Assume sales grow at 17% instead of 12%. How much total long-term debt would be required?
