ProForma Fin425.xlsx This port

SoccerBoss
Category:
Business & Finance
Price: $60 USD

Question description

ProForma Fin425.xlsx This portion of the exercise is intended to enhance your Excel skills. Generate pro-forma income statements and balance sheets for the first three years of the proposed business. Submit by email by midnight on the due date a well-organized Excel spreadsheet containing the pro-forma results. Also, turn-in an appropriate and well-formatted printout of the pro-forma statements attached to the loan request letter. Incorporate the following Excel components from the Excel manual into the spreadsheet (see the grading rubric attached to the syllabus): 1) Create an Excel Data Table that lists the projected second-year income and interest expense for your firm under five sales growth scenarios, e.g. 0%, 5%, 10%, 15%, or 20% sales growth. [Variable Data Tables, MacDonald] 2) Create a Drop-Down User Input Cell with five choices for the firm’s growth prospects: Poor, OK, Expected, Good, & High [Data Validation with Lists, MacDonald]. 3) Place Formulas in two nearby output-cells that display the corresponding net income and interest expense amounts listed in the data table from part (a). Use the Excel Lookup Function [MacDonald] with Nested Excel “If” Statements [ MacDonald] to extract the data from the data table. Use Nested Excel “If” Statements to translate the user selection from the drop-down input in part (b) to one of the percentage sales growths used to form the data table in part (a), e.g. if the user selects “Expected”, the if statement returns 10% (0.10). Use the Lookup Function to find and display the net income and interest expense corresponding to the given sales growth in the data table. 4) Generate a Well-Formatted Chart [MacDonald] to display the data listed in the data table from part (a). 5) Use labels and formatting as appropriate to guide the user in using the functionality added in parts (a) – (c). 

Tutor Answer

(Top Tutor) Daniel C.
(997)
School: UIUC
PREMIUM TUTOR
Studypool has helped 1,244,100 students
Ask your homework questions. Receive quality answers!

Type your question here (or upload an image)

1830 tutors are online

Brown University





1271 Tutors

California Institute of Technology




2131 Tutors

Carnegie Mellon University




982 Tutors

Columbia University





1256 Tutors

Dartmouth University





2113 Tutors

Emory University





2279 Tutors

Harvard University





599 Tutors

Massachusetts Institute of Technology



2319 Tutors

New York University





1645 Tutors

Notre Dam University





1911 Tutors

Oklahoma University





2122 Tutors

Pennsylvania State University





932 Tutors

Princeton University





1211 Tutors

Stanford University





983 Tutors

University of California





1282 Tutors

Oxford University





123 Tutors

Yale University





2325 Tutors