Preview Workflow

Viewing: BUS 429 : Financial Modeling

Last approved: Fri, 28 Apr 2017 08:02:13 GMT

Last edit: Fri, 28 Apr 2017 08:02:13 GMT

Change Type
Major
BUS (Business Management)
429
032447
Dual-Level Course
No
Cross-listed Course
No
Financial Modeling
Financial Modeling
Poole College of Management
Business Management (20BUS)
Term Offering
Fall and Spring
Offered Every Year
Spring 2017
Previously taught as Special Topics?
No
 
Course Delivery
Face-to-Face (On Campus)

Grading Method
Graded with S/U option
3
16
Contact Hours
(Per Week)
Component TypeContact Hours
Lecture3
Course Attribute(s)


If your course includes any of the following competencies, check all that apply.
University Competencies

Course Is Repeatable for Credit
No
 
 
Jared Smith
Assistant Professor

Open when course_delivery = campus OR course_delivery = blended OR course_delivery = flip
Enrollment ComponentPer SemesterPer SectionMultiple Sections?Comments
Lecture9045YesN/A
Open when course_delivery = distance OR course_delivery = online OR course_delivery = remote
Prerequisite: BUS 320
Is the course required or an elective for a Curriculum?
No
BUS 429 is 'corporate finance in Excel.' Starting from the theoretical base gained in BUS320, students work through problems in time value of money, capital budgeting, and valuation (among other things) using spreadsheet analyses. The course will take a very hands-on approach in building financial spreadsheet models. Microsoft Excel is the primary tool we will use to implement these financial models and the course will go into detail on the proficient use of Excel.

This course will add skills that employers are asking for, as well as keeping pace with peer institutions that have added similar courses.


No

Is this a GEP Course?
No
GEP Categories

Humanities Open when gep_category = HUM
Each course in the Humanities category of the General Education Program will provide instruction and guidance that help students to:
 
 

 
 

 
 

 
 

 
 

 
 

Mathematical Sciences Open when gep_category = MATH
Each course in the Mathematial Sciences category of the General Education Program will provide instruction and guidance that help students to:
 
 

 
 

 
 

 
 

Natural Sciences Open when gep_category = NATSCI
Each course in the Natural Sciences category of the General Education Program will provide instruction and guidance that help students to:
 
 

 
 

 
 

 
 

Social Sciences Open when gep_category = SOCSCI
Each course in the Social Sciences category of the General Education Program will provide instruction and guidance that help students to:
 
 

 
 

 
 

 
 

 
 

 
 

Interdisciplinary Perspectives Open when gep_category = INTERDISC
Each course in the Interdisciplinary Perspectives category of the General Education Program will provide instruction and guidance that help students to:
 
 

 
 

 
 

 
 

 
 

 
 

 
 

 
 

Visual & Performing Arts Open when gep_category = VPA
Each course in the Visual and Performing Arts category of the General Education Program will provide instruction and guidance that help students to:
 
 

 
 

 
 

 
 

 
 

 
 

Health and Exercise Studies Open when gep_category = HES
Each course in the Health and Exercise Studies category of the General Education Program will provide instruction and guidance that help students to:
 
 

 
 

 
 

 
 

 
&
 

 
 

 
 

 
 

Global Knowledge Open when gep_category = GLOBAL
Each course in the Global Knowledge category of the General Education Program will provide instruction and guidance that help students to achieve objective #1 plus at least one of objectives 2, 3, and 4:
 
 

 
 

 
Please complete at least 1 of the following student objectives.
 

 
 

 
 

 
 

 
 

 
 

US Diversity Open when gep_category = USDIV
Each course in the US Diversity category of the General Education Program will provide instruction and guidance that help students to achieve at least 2 of the following objectives:
Please complete at least 2 of the following student objectives.
 
 

 
 

 
 

 
 

 
 

 
 

 
 

 
 

Requisites and Scheduling
 
a. If seats are restricted, describe the restrictions being applied.
 

 
b. Is this restriction listed in the course catalog description for the course?
 

 
List all course pre-requisites, co-requisites, and restrictive statements (ex: Jr standing; Chemistry majors only). If none, state none.
 

 
List any discipline specific background or skills that a student is expected to have prior to taking this course. If none, state none. (ex: ability to analyze historical text; prepare a lesson plan)
 

Additional Information
Complete the following 3 questions or attach a syllabus that includes this information. If a 400-level or dual level course, a syllabus is required.
 
Title and author of any required text or publications.
 

 
Major topics to be covered and required readings including laboratory and studio topics.
 

 
List any required field trips, out of class activities, and/or guest speakers.
 

No additional new resources needed as the course will be covered by current faculty by reducing the number of sections of current courses that are offered each semester to add sections of this course.

  1. Develop proficiency with Microsoft Excel. 

  2. Understand spreadsheet design and gain the skills to analyze financial problems.

  3. Use estimated costs of capital and cash flows to complete a high-level analysis of a project or firm.

  4. Gain the ability to identify key factors affecting financial forecasts.

  5. Improve written communication skills in relation to finance.


Student Learning Outcomes

1.    Utilize Microsoft Excel to analyze financial problems.

2.    Complete a high-level analysis of a project or firm, using estimated costs of capital and cash flows.

3.    Identify key factors affecting financial forecasts.

4.    Demonstrate the ability to write financial reports


Evaluation MethodWeighting/Points for EachDetails
Homework255 assignments at 5 points each
Participation10N/A
Multiple exams40Two exams at 20 points each
Final Exam25One final exam

aeherget (Fri, 31 Mar 2017 15:42:02 GMT): AECHH: Uploading updated syllabus at initiator's request via email 3/31/2017.
Key: 14449