FINA 306-15 A
Chapter 1:Personal Financial Planning
Professional Application Questions
(a) Why do you think that many people
show2 a low level of interest in their
Personal Financial Planning
Q. 3.1, 3.2, 3.7, 3.9, 3.10 and 3.13
What are the general conditions that need to be
satisfied for an expense to be considered an
allowable deduction for tax purposes?
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.
e image while writing your
Box looks like the image pr
Problem 1 (30%)
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 results are linked with Pivot table
FINA 415-15B Exam
PART 1 Excel
TVM & Matrix
This is part 1 of the Exam.
Please enter your answers in the Yellow Area.
Save your work frequently, there will be no time extension for work lost d
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 Function display as True if
1.debttoassets greater than
Introducing Excel functions and
Basic Financial Calculations
FINA 415-15B Nirosha Wellalage
FINA 415-15B Nirosha Wellalage
screen is called a
Nirosha Wellalage-FINA 415-15B
This week will covers
Lookup & Reference
Match & Index
Graph and Charts
Nirosha Wellalage-FINA 415-15B
If(), Vlookup(), and Hlookup ()are three functions that allow you to put
Option 1 (Cell A1)
Option 2 (Cell A2)
It is for us the living rather to be dedicated here to the unfinished work which they who fought here
FINA 415-15B NIROSHA HEWA WELLALAGE
This week covers
A dollar today is worth more than a dollar tomorrow.
FINA 415-14B NIROSHA HEWA WE
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
function BANKFV (CF, r, n)
For Periodical Deposits
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 below. Use
worksheet Loan Amortization A to develop your so
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 university education. He will begin university when he turn
MySuper is part of the Stronger Super reforms announced in 2011 by the Julia Gillard-led government
for the Australian superannuation industry. From 1 January 2014, employers must only pay default
superannuation contributions to an authorised MySuper p
THE MONEY MARKET
The role of the market
Money market securities
Trading and settlement arrangements
Short-term interest rates and monetary policy
Identify and explain the contributions of the money m
Your employer's contributions
If you're eligible, your employer will also contribute to your KiwiSaver savings.
Compulsory employer contributions
If you're a KiwiSaver member making contributions from your pay, your employer also has to put money
Chapter 8: The bond market
1. Most bonds pay a series of coupon payments and are redeemed on their maturity date by the payment
of their face value.
There are many types of bonds but these are the features of a standard bond.
Chapter 5: Authorised deposit-taking institutions
1. ADIs accept deposits and make loans.
While deposit taking and lending are the traditional activities of ADIs, some concentrate on the
provision of these services and others concentrate
Chapter 1: Overview of the financial system
1. Australia went through a process of increasing regulations on the financial system in the 1980s.
Deregulation in the 1980s removed many regulations on banks and financial markets and contrib
Chapter 4: Funds management
1. Fund managers arrange the collective investment of (mainly) retail investments.
The fund manager manages the funds on behalf of investors/contributors.
2. Funds management
Chapter 10: The share market
1. The ASX was formed from the amalgamation of the state-based exchanges.
This occurred in 1987.
2. The ASX is the Australian Stock Exchange Limited.
This was the pre
Chapter 9: Shares
1. The financing decision is a firms decision about which assets or projects it will invest in.
The financing decision is a firms decision about how assets are financed, such as the amount of debt
used relative to equit
Chapter 2: The payments system
1. Barter is a system of exchange in which items (or services) are exchanged for each other.
This system requires a coincidence of wants in order for an exchange to occur.
Chapter 3: Introduction to the flow of funds
1. In the financial markets, surplus and deficit units deal directly with each other without any assistance
from financial institutions.
Deficit units are generally assisted by investment bank
Chapter 7: The money market
1. The money market facilitates direct financing in wholesale amounts.
Issuers of securities include banks, non-financial companies and governments. Investors include banks
and institutional investors.
Chapter 6: The stability of deposit-taking institutions
1. Banks may face losses as a result of events that are beyond their control.
They need to have adequate equity funds to cover unexpected losses and have access to funds should
Name Zhonghui Ji
Student ID 1291791
1. What is operating cash flow? In comparing accounting net income and operating cash flow,
name two items you typically find in net income that are not in operating cash
FINA312 / FINA517 15B
TUTORIAL SESSION 01
The basic trade-off in the investment process is
a. between the anticipated rate of return for a given investment instrument and its
degree of risk.
b. between understanding the nature of a particula
FINA312 / 517
PORTFOLIOS AND MARKETS
THE EFFICIENT MARKET
Chapter 11 Questions
What do we mean when we say that capital
markets are efficient?
Why should capital markets be efficient?
What factors contribute to an efficient