PROJECT NPV
(in thousands of $)
Year 0
Year 1
Year 2
Year 3
Year 4
Year 5
Year 6
Year 7
Key Assumptions
Base Case Unit Sales
Unit Sales Adjusted by Scale Factor
Inflation Rate
Real Cost of Capital
Tax Rate
7500
7500
1.50%
9.30%
39.00%
10125
10125
1.83%
9.
HOMEWORK 1, Financial Modeling 3103
DUE 2/10/2016 at 5:00 pm CST
A
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
B
C
D
363
433
415
405
372
316
286
288
2878 Find the SUM of the numbers (use SUM)
359.75 Find the AVERAGE of the numbers (use SUM/N)
359.75 Find the AVER
Caleb Petersen
Finn 3003
DJIA Semester Project
8/29/16:
Opening
Closing
Change
18,395.40
18,502.99
+107.59
Todays market is seeing positive growth, potentially due to market confidence in the fact that
the Federal Reserve will not raise interest rates unl
COURSE OVERVIEW AND
INTRODUCTION
Motivation
Introduction to Excel
WHY FINANCIAL MODELING?
You need $1,000 in two years. Your bank
pays 10% interest. How much to save each
year?
You want to buy a house to rent it out. How
should you evaluate this decision?
I.
Chapter 5:
Objectives- Describe the types and functions of financial institutions, describe banking
services offered by financial institutions, Identify components of interest rates.
A. Types of financial institutions
1. Depository institutions: Financ
Anna just turned 35 and is reviewing her retirement savings. Her current balance in her 401(k) is $145,000. She
plans on retiring at age 65 (exactly 30 years hence) and wants to begin withdrawals one month later. She believes
that she'll need $9,000 per m
Cost per Unit
Power Generated
Number of Turbines
Lifespan
Maintenance Per turbine
Current Price of Power
2000000
4500
12
12
100000
93.0108377831
2000000
4950
12
12
100000
100
Total Investment
Annual Depreciation Change
$ 24,000,000.00
$ 2,000,000.00
24000
Names:
Ramsey Cave
Instructions: Please complete the vertical and horizontal common form analysis and the
ratio analysis for Nike, Inc .on the form presented below. Put your answers in the shaded
boxes provided below. You may use Excel to complete the for
Name:
Ramsey Cave
Instructions: Please complete the proforma Income Statement and Balance Sheets for 2015.
Put your answers in the shaded area provided below. You may use Excel to complete the form
Print the form and staple the two pages together for subm
Principles of Finance
Finance forecasting, sourcing, allocating, and controlling of cash for a
company or individual
Concerned with decisions about capital or cash
To make sound financial decisions, one must remember:
o Cash is King
o More value is pref
Principles of Finance
Exam 2
Recognize Revenue
Selling company has completed most of the activities associated with
producing and selling the product
Selling company has incurred the costs associated with producing and
selling the product or can reasona
Name and Class Student #
Ramsey Cave #9
Instructions: Please complete the proforma Income Statement and Balance Sheets for 2015.
Put answers only in the shaded area provided below. You may use Excel to complete the form
Print the form and staple the two p
Name: _Ramsey Cave_ Class # _9_
Bond and Stock Valuation Homework
Please following these instructions completely. Complete the following using a
computer (hand writing only for problems), print out, staple your pages together
and bring to class for submis
NAME: _
TIME VALUE OF MONEY HOMEWORK
Please following these instructions completely. Using the text (do not use Investopedia or
Wikipedia), complete the following using a computer (hand writing only for problems). Then
print it out, staple your pages toge
REAL ESTATE TEST 3 NOTES
11/3/15
Missed last class test over chapter 16-22
Chapter 16 (closes) Closing statement
~An accounting of the expenses of a real estate contract. What are
expenses and who pays for them. H.U.D closing statement (owner
occupied and
Gross profit= Revenue-Cost of goods sold
Cost of goods sold=beginning inventory+ purchases- ending inventory
Operating income=gross profit-operating expenses
Taxable income=operating income- net interest expense+ other income (expenses)
Net income=taxable