Did I use the right methods to solve the financial forecast problem? I uploaded the excel file in the link below. The bolded 2007 are my answers.

How would I solve for the last question."The company is presently
operating at 15% of capacity.If the company plans to use long-term debt
to raise capital, how much will they need?"

I have a hard time uploading attachments on here so this is where the excel file is located

http://www.filedropper.com/14elvisproductsfinancials