ACST603 Principles of Finance S2 - Review of Online Borrowing Power Calculator Case Study - Review of Online Borrowing Financial Dataset on Stock Prices Case Study - Finance Assignment Help

ACST603 Principles of Finance S2 Assignment Help

Assignment Task:

TASK 1:
CASE STUDY – REVIEW OF ONLINE BORROWING POWER CALCULATOR FOR THIS EXERCISE WE PLAN TO ANALYSE / CRITIQUE / REVIEW AN ONLINE FINANCIAL CALCULATOR THE URL FOR THE CALCULATOR IS:

YOUR TASKS IN RELATION TO THIS ARE AS FOLLOWS
1. GIVE A BRIEF DESCRIPTION OF HOW A LENDER MAY DECIDE THE SIZE OF AN AMORTISING LOAN THEY WOULD MAKE TO A BORROWER FOR BUYING REAL ESTATE. THIS CAN BE COMPUTED USING THE EXCEL PV FUNCTION. WHAT WOULD BE THE INPUTS TO THE EXCEL PV FUNCTION?

2. GIVE A BRIEF DESCRIPTION OF WHAT THE CALCULATOR PRODUCES?

3. THERE ARE VARIOUS ASSUMPTIONS BUILT IN TO THE CALCULATOR. TO VIEW THESE, CLICK ON THE “ASSUMPTIONS” LINK. THESE HAVE DEFAULT VALUES BUT THE USER CAN CHANGE SOME OR ALL OF THESE VALUES. WHAT ARE THESE ASSUMPTIONS? IDENTIFY THEM. HOW
REASONABLE ARE THE FOLLOWING ASSUMPTIUONS?
A. INTEREST RATE BUFFER.
B. MAX % OF AVAILABLE INCOME.
C. LENGTH OF MONTH, NUMBER OF WEEKS AND FORTHNIGHTS IN A YEAR.

4. CHECK WHAT RESULTS YOU GET FROM USING THE ONLINE CALCULATOR USING THE FOLLOWING SCENARIOS/SETS OF INPUTS IN TABLE 1. DO YOUR  RESULTS MATCH THOSE BELOW FOR THE LOAN SIZE AND LOAN REPAYMENT FOR SCENARIO 1 AND 6 ONLY

5. HOW COULD YOU USE THE EXCEL PMT FUNCTION FOR COMPUTING THE PAYMENT PER MONTH RESPECTIVELY FOR AN AMORTISING LOAN? WHAT WOULD BE THE INPUTS TO THOSE EXCEL FUNCTIONS/ ILLUSTRATE THIS BY IDENTIFYING THE VALUES OF THE INPUTS FOR SCENATIO 1 ABOVE.

TASK 2:
CASE STUDY – REVIEW OF ONLINE FINANCIAL DATASET ON STOCK PRICES FOR THIS EXERCISE WE PLAN TO RESEARCH/ ANALYSE/CRITIQUE /REVIEW AN ONLINE WEBSITE FOR FINANCIAL HISTORICAL DATA

YOUR TASKS IN RELATION TO THIS ARE AS FOLLOWS
1) IN THE SEARCH TOOL TYPE IN PFIZER INC (PFE). EXTRACT THE FINANCIAL HISTORICAL DATA ON SHARE PRICES FOR PFIZER FROM 30/06/2014 TO ON A DAILY BASIS.

2) REVIEW THE DATA SET YOU HAVE EXTRACTED AND CALCULATE THE FOLLOWING STATISTICS: A. FIND THE HOLDING PERIOD RETURN (HPR) FROM 1/07/2014 ONWARDS ON A DAILY BASIS (CONSIDER DIVIDEND AND STOCK SPLIT ARE REFLECTED IN THE HPR)

B. COMPUTE THE STANDARED DEVIATION OF THE HPR PER DAY FOR EACH OF THE YEARS (STARTING FROM 2/07/2014). WORKOUT THE LOW AND HIGH HPR RETURNS FOR EACH YEAR. DRAW A LINE CHART AND COMMENT ON YOUR ANALYSIS IN TERMS OF IF ANY TRENDS / SIMILARITIES / DIFFERENCES OVER THE PAST FIVE YEARS. EXPLAIN YOUR REASONING. (NOTE: USE THE ATTACHED SPREADSHEET TO SHOW YOUR ANALYSIS AND WORKOUT. DO NOT CHANGE THE TEMPLATE OF THE SPREADSHEET)

This Finance Assignment has been solved by our Finance experts at My Uni Paper. Our Assignment Writing Experts are efficient to provide a fresh solution to this question. We are serving more than 10000+ Students in Australia, UK & US by helping them to score HD in their academics. Our experts are well trained to follow all marking rubrics & referencing style.

Be it a used or new solution, the quality of the work submitted by our assignment experts remains unhampered. You may continue to expect the same or even better quality with the used and new assignment solution files respectively. There’s one thing to be noticed that you could choose one between the two and acquire an HD either way. You could choose a new assignment solution file to get yourself an exclusive, plagiarism (with free Turnitin file), expert quality assignment or order an old solution file that was considered worthy of the highest distinction.