Function F(A, B, C, D, E)
F = A / B + E / D + (C + D) / E + (A + B) ^ 2
End Function
Question 1
Function G(A, B, C, D, E)
G = Log(A / B) + Exp(C / D) + Cos(E / D)
End Function
Function MySumsq1(X)
Sum
Exam_average Letter grade
93.58
A
82.08
B
98.50
A
66.00
D
93.92
A
68.17
D
90.83
A
95.67
A
79.58
B
75.67
C
85.08
B
86.50
B
91.25
A
88.17
B
81.00
B
84.00
B
96.00
A
79.00
C
78.83
C
68.83
D
65.92
D
70.75
Future Value Calculations
Present Value
($1,000)
Number of Payment
120
Rate
10%
Future Value
Present Value Calculations
Future Value
$1,000
Number of Payment
4
Rate
10%
Present Value
Present Value of
Fall 2014
Cooper
FIN 555
Amortization schedule for $300,000, ten-year loan with an interest
rate of 10%
Loan Amount
Interest rate
Term of Loan (years)
Payments per Ye
Monthly payment
Month
1
2
3
4
5
6
Fun Problems
1. The Orange company has had earnings growth of 20% for the past 5 years and has a
reasonable expectation that earnings will continue at that rate for the next ﬁve years.
Most analyst be
Instructions
Put the names and email adresses of each student who works on this homework into the sheet titled "Your Info".
Remember that you should only work in groups of three or fewer.
The remaing
Fi 398 Final Exam Questions
8 questions
Tuesday 2:30-5:00
1. Capital budgeting (#13, M2 #11)
o This is where you use NPV, lRR and SOLVER
0 See notes for how to use solver
0 See April 13th Notes
2. Opt
PracticemMidthICQMH
i. , J “Wust
Fl/EC 389; Spring 2012
Take the prices of the stocks in the Pl sheet. Calculate the following for each stock
and record your results in the spaces provided below:
Preparation for Final
FI/EC 389 Spring 2012
Calculate the following for each stock and record your results in the spaces provided: Use
population variance and standard deviation. Using the tools menu
Scale problem
Discount rat
0.13
Project
0
1
A
-$500
$750
B
#
#
IRR
0.50
NPV
$164
0.20
$6,195
What if projects were mutually exclusive?
Discount rat
0.13
Project
A
0
#
1
#
3
#
4
5
$5,000 $5,000
Payback
Date
1 mo 3 mo 6 mo 1 yr 2 yr 3 yr 5 yr 7 yr 10 yr 20 yr 30 yr
2/24/2017 0.4 0.52 0.65 0.8 1.12 1.38 1.8 2.12 2.31 2.69 2.95
2/27/2017 0.44 0.5 0.68 0.81 1.2 1.46 1.87 2.18 2.36 2.72 2.98
2/28/2017 0.
Golf Cart Diversified Industries Corp.
Required rate of return
Tax rate
Operating cost as a percentage of sales
Cost of machine
Investment in NWC
Projected sales
Operating costs
Depreciation expense
P
A
Quarterly Profits
Region
Quarter
West
West
West
West
West
West
West
West
1
2
3
4
1
2
3
4
South
South
South
South
West
West
West
West
East
East
East
East
West
West
West
West
West
West
West
West
South
Type
A few of the available data types
Boolean True or False
Double
Precise decimal numbers
Integer
Counting numbers
String
Text
Example of some simple add functions that demonstrate type declarations
Global Travel
Author
Date
Danesha
2/17/2015
Purpose
New Mexico theme park ticket sales
New Mexico
Global Travel
Theme Park Ticket Sales-Quarter 1
# Tickets Sold
Adults
Children
Animal Habitat
116
Glob
New Century Fund
Author
Date
Purpose
To report on the performance and financial details
of the New Century mutual fund
New Century
New Century Fund Report
Summary Report
New Century Fund
Summary Repor
M-Fresh Water Company
Author:
Date:
Danesha Prewit
2/25/2015
Purpose
Calculate water bills for commercial businesses
Quarterly Data
Customer Name
Red Lake Chapter
Amity Church
Church of Christ
NM Stat
The Crockett Family Portfolio
Author
Date
Purpose
Danesha Prewit
2/5/2015
To report on the investment portfolio of Brian and
Tammy Crocket
Crockett Family Portfolio
tfolio
Crocket Family Portfolio
Cro
Eugene Community Theatre
Author:
Date:
Danesha
2/24/2015
Purpose:
Prepare invoices for theatre patrons
Invoice Data
Invoice Date
7/15/2013
Subscriber
Michael Keller
Address
4321 Main Street
City State
Global Travel
Author
Date
Purpose
Colorado theme park ticket sales
Colorado
Fiscal Year - 2013
Animal Habitat
Global Workplaces Florida
Space Adventure
Sea Aquarium Orlando
Dade Water Park
City Studio
Instructions
Put the names and email adresses of each student who works on this homework into the sheet titled "Your Info".
Remember that you should only work in groups of three or fewer.
The remaing
Instructions
Put the names and email adresses of each student who works on this homework into the sheet titled "Your Info".
Remember that you should only work in groups of three or fewer.
The remaing
Instructions
Put the names and email adresses of each student who works on this homework into the sheet titled "Your Info".
Remember that you should only work in groups of three or fewer.
The remaing