Pro Forma Income Statement and Sustainable Growth Calculation

I have attached 3 sample problems I found online very similar to the concepts I need help with.

The excel spreadsheet contains a sample income statement and balance sheet. I need to understand how to create a proforma income statement and balance sheet using the data from 2004. Additionally, I need to indicate if additional financing (long term and short term options) is necessary. Please create the statements and explain (if there is a need) for additional financing and what options are available.

On the other attachment, With Sample questions 2 & 3, please calculate and explain how you arrived at the solutions. If possible please explain step by step, I'll be attempting several questions like these and with a detailed explaination I think I can figure it out.

Thank you in advance. Any help provided is greatly appreciated!

Attachments