For this assignment, complete problems 17-7 (one year pro forma

 will typically be 2–3 pages in length as a general expectation/estimate as well with the Excel sheet

 In addition, provide two or more suggestions on what Arrington, Inc. could do to reduce the forecasted debt financing (the managerial part of financing). Be sure to provide rationales as to why your suggestions will be effective in reducing the forecasted debt financing need. 

 1. Student uses Excel spreadsheet, and the formulas and calculations are correct. 

2. Student provides an accurate pro forma income statement using assumptions given in Problem 17-7 which yields a correct forecast for Roberts’ year-end net income and he/she documents assumptions used and rationales for each forecasted element of the pro forma statement. 

 3. Student provides a thorough and detailed explanation using assumptions given in Problem 17-8 and correctly answers the question about how much Ambrose’s total liabilities was in 2015, and provides a rationale for any formula(s) used to compute the total debt figure as well as formula inputs. 

 4. Student provides a thorough and detailed explanation using assumptions given in Problem 17-8 and correctly answers the question about how much Ambrose will need for long-term debt financing in 2016, and provides two or more suggestions on what Ambrose could do to reduce the forecasted debt financing with rationales for suggestions provided.