Student ID
1
2
3
4
5
Student Name
Time Value of Money (65%)
PLEASE ENTER YOUR RESULTS INTO YELLOW CELLS & SHOW ALL WORKING IN THE DRAFT AREA
Problem 1 (4%)
You plan to start saving for your sons unive
Loan Amortization Table and Chart
a. Your client asks you to develop an amortization table and chart (displays principal
and interests) for his mortgage (table loan) with the specifications given belo
FINA 515
Assignment Requirements
Assume these are financial data that have been extracted by your research
assistant from prospectuses of New Zealand Non-bank Financial Institutions
. (NBFIs). The dat
Project-VBA Presentation
This is group presentation (All members in group need to present)
Video Submission
As a students who study Computer Modelling paper we recognizes the importance of media and t
Summary
This project aims to apply the Geometric Brownian Motion to stock price simulations,
which build a financial model to simulate stock prices over time. The method of this
project is to use Micr
The University of Waikato
Private Bag 3105
Hamilton
New Zealand
Full Name: XiangtianYu Zhengchang Liu Haocheng Liu LujueQiu Runyu Wu
ID Number:
1319382
1317630
1317548
1317667 1319379
Tutorial: 0
Pape
FINA 515
Assignment Requirements
Assume these are financial data that have been extracted by your research assistant from
prospectuses of New Zealand Non-bank Financial Institutions (NBFIs). The data
Income
Income
Tax Rate
VLOOK UP
Tax Rate
0
0%
800
15%
14000
25%
25000
38%
15000
0.25
Example 2: Using the tablebelow, write an Horizontal LookUp formula to find the Maths marks of a student who
Studen
Attempt all questions and incorporate all features shown in the image while writ
programe. More marks wiil be given if your Input Box and MsgBox looks like the
Please save your excel as macro enabled.
Problem 1 (30%)
Student Name
PLEASE ENTER YOUR RESULTS INTO YELLOW CELLS
Analysis of Data on Banks with Pivot Tables. Worksheet Banks data contains a list of informati
Full marks will be given only re
FINA 415 -15B Homework -5
1. A bank offers different interest rates on deposit accounts. The rate is based on the
size of the periodical deposit (CF) and the following table. Write a future value
func
WEEK-02
FINA 415-15B
FINA 415-15B NIROSHA HEWA WELLALAGE
1
This week covers
TimeValueofMoneycalculations
FV
AdvancedExcelFunctions
Math&TrigCategory
MatrixMultiplication
A dollar today is worth mo
1
0
Option 1 (Cell A1)
Option 2 (Cell A2)
August
January
February
March
April
May
June
July
August
September
October
November
December
Click Me
_x000D_
It is for us the living rather to be dedicated
Student ID
1
2
3
4
5
Student Name
Problem 1 (10%)
Group ownership field into following 3 categories
Group A= Ownership =0
Group B= Ownership is >0 and < 0.75
Group C = Ownership is >= 0.75
Using AND F
FINA 415-15B Exam
PART 1 Excel
#
1
2
3
4
5
Worksheet Name
Solver
Match
TVM & Matrix
Pivot table
Data Table
This is part 1 of the Exam.
Please enter your answers in the Yellow Area.
Save your work freq
DATA TABLES
Draw a data table that shows the NPV of this project as a function of
- the initial investment
- the discount rate (r)
Use conditional formating (Menu FORMAT) to show all cells with negati
FINA 515-14B Exam
Part A
# Worksheet Name
Description
1 Look Up Function
Look up function, Match and Index (15 marks)
Pivot table analysis (15 marks)
2 Pivot table
Offset Function
Dynamic
3This is the
A
B
C
D
F
G
H
I
MATRICES IN EXCEL
1
2
3
4
5 Matrix A (a row vector)
2
3
6
7
8
9
10 Matrix D (a 4 x 3 matrix)
13
-8
11
-8
10
12
-3
-1
13
0
13
14
E
4
-3
-1
11
3
Matrix B (a square 3 x 3 matrix)
13
-8
-3