4873 Practice Skills

PRACTICE SKILLS

FIN 4873

Instructions	Spreadsheet	*Video*	Topic
Exercise 1	Exercise 1	Exercise 1	*General Skills*
Exercise 2	Exercise 2		*Graphs*
Exercise 3	Exercise 3		*IF Statements, AND/OR Functions*
Exercise 4	Exercise 4		*Additional Functions*
Exercise 5	Exercise 5		*Database Functions*
Exercise 6	Exercise 6		*Regression Analysis*
Exercise 7	Exercise 7		*Income Statements*
Exercise 8	Exercise 8		*Balance Sheets*
Exercise 9	Exercise 9		*Statement of Cash Flows*
Write-up of Progression	Original Spreadsheet		*Integrated Financial Proformas*
Proforma Practice	Part 1		*First Class results*
Proforma Practice	Part 2		*Second Class results*
Proforma Practice	Part 3		*Third Class results*
Proforma Practice	Part 4		*Fourth Class results*
Proforma Practice	Part 5		*Fifth Class results*
Proforma Practice	Debt Option		*Financing the Project with Debt*
Proforma Practice	Equity Option		*Financing the Project with Equity*
Exercise 10	Exercise 10		*Creating a Flexible Loan Model*
Working Loan Model	Loan Model		*Finalized Version of Flexible Loan (Exercise 10)*
Exercise 11	Exercise 11		*Creating User-Friendly Drop-down Boxes*
Exercise 12	Exercise 12		*Create Macros to Execute Results*
Exercise 13	Exercise 13		*An Additional Macro Example*
Exercise 14	Exercise 14		*Creating User Forms*