(Please show excel working tab) Question 1 (25 marks) Design an Excel financial model that can...

(Please show excel working tab)

Question 1
Design an Excel financial model that can help to answer the following parts (part 1 - 3). 5 marks will be allocated for the presentation and clarity of your model (e.g., if there are clear headings, clear arrangement for input cells, appropriate use of colors, have some degree of flexibility, generate warning messages for wrong user inputs, etc.).

Part 1

Suppose you receive $100 at the end of each year for the next three years.

a.
If the interest rate is 8% per annum (interest paid annually), what is the present value of these cash flows?

b.
What is the future value in three years of the present value you computed in part (a)?

c.
Assume that no withdrawals are made from the savings account until the end of the third year. What is the interest component?

d.
Compute the effective 3 years rate (total interest over 3 years). Hint: EFFECT function is not appropriate for this part as it is often used to compute an effective annual interest rate from a nominal interest rate.

Part 2

Your uncle has just announced that he is going to give you $15,000 per year at the end of each of the next 4 years.

a.
If the relevant interest rate is 7%, what is the value today of this promise?

b.
If the interest rate changes to 8%, what is the value today of this promise?

c.
Explain how interest rates influence the value of the promise in parts (a) and (b).

Solutions

Expert Solution

jeff jeffy answered 1 year ago

Next > < Previous

Related Solutions

Hi, I can't figure out this question in excel, can someone please show me the excel...

Hi, I can't figure out this question in excel, can someone please show me the excel formulas to input in order to solve for part A and B please!!!! The following table contains closing monthly stock prices for Oracle Corporation (ORCL), Microsoft Corporation (MSFT), and NVidia (NVDA) for the first half of 2017. Ticker 6/30/2017 5/31/2017 4/30/2017 3/31/2017 2/28/2017 1/31/2017 ORCL 50.14 45.39 44.96 44.61 42.59 40.11 MSFT 68.93 69.84 68.46 65.86 63.98 64.65 NVDA 144.56 144.35 104.3 108.93 101.48...

In the Excel data file, the tab labeled Question 1 contains data on the number of...

In the Excel data file, the tab labeled Question 1 contains data on the number of times boys and girls raise their hands in class. Conduct the t-test: Two-Sample Assuming Equal Variances. Males 9,8,4,9,3,8,10,8,9,10,7,6,12 Females 3,5,1,2,6,4,3,6,7,9,7,3,7,6,8,8 a. What is the null hypothesis? b. What is the research hypothesis? c. Why run a Two-Sample Assuming Equal Variances t-test? d. Interpret the findings. What are the results of the hypothesis test? Can you reject the null hypothesis?

Question 1 (25 marks) a) In the industry-lifecycle model, explain which stage the vaping industry is...

Question 1 a) In the industry-lifecycle model, explain which stage the vaping industry is in and why? Explain the theory with case-specific examples to support your position. b) In the industry-lifecycle model, explain which stage the general cigarette/tobacco industry is in and why? Explain the theory with case-specific examples to support your position. c) Identify and discuss what can a company do to deal with declining sales in an industry? Question 2 Is Juul a socially responsible company? Why or...

The Markov Model on Excel tab depicts the population of Warrant Officers in the Marine Corps....

The Markov Model on Excel tab depicts the population of Warrant Officers in the Marine Corps. A Warrant Officer is individual who has spent considerable enlisted time acquiring a high level of expertise in an occupational specialty and is awarded an officer’s commission to fill various leadership roles in that community. There are five grades (WO-CWO5). In the system we model here, there are three absorbing states. Two are self-explanatory (resign, retire) but the other is transition/promotion to Limited Duty...

How can I solve this in Excel? Please show how to solve it in excel step...

How can I solve this in Excel? Please show how to solve it in excel step by step. 1) Speedy Wheels is a wholesale distributor of bicycles for the western United States. Its Inventory Manager, Ricky Sapolo, is currently reviewing the inventory policy for one popular model — a small, one-speed girl's bicycle that is selling at the rate of 250 per month. The administrative cost for placing an order for this model from the manufacturer is $200 and the...

COULD YOU PRETTY PLEASE show this in WORKING NOT EXCEL 5. A bond has maturity of...

COULD YOU PRETTY PLEASE show this in WORKING NOT EXCEL 5. A bond has maturity of 7 years and pays a 7% coupon rate (with coupon paid annually).The bond sells at par value. (1) Calculate the duration and convexity of the bond. 2 (2) Assuming its yield to maturity increases from 7% to 8% with maturity unchanged. Calculate the predicted price using modified duration rule, and the percentage error of this rule. (3) Assuming its yield to maturity increases from...

SHOW YOUR WORK not only the solutions, on worksheet tab in Excel file A fully amortizing...

SHOW YOUR WORK not only the solutions, on worksheet tab in Excel file A fully amortizing mortgage loan is made for $80,000 at 6 percent interest for 25 years. Payments are to be made monthly. Calculate: a. Monthly payments. b. Interest and principal payments during month 1. c. Total principal and total interest paid over 25 years. d. The outstanding loan balance if the loan is repaid at the end of year 10. e. Total monthly interest and principal payments...

Please show how to do in Excel Using Log-log model to estimate the demand function Model:...

Please show how to do in Excel Using Log-log model to estimate the demand function Model: log(sales) = a + b * log(price) + error Explain the results in term of how price affects sales. Market ID Sales Price Advertising 1 367 2.2 Yes 2 165 2.7 No 3 366 2.4 Yes 4 148 2.9 No 5 152 2.8 No 6 198 2.2 No 7 390 2 Yes 8 367 2.3 Yes 9 210 2.1 No 10 353 2.7 Yes...

QUESTION 2 (25 MARKS) The following are the statements of financial position as at 31 December...

QUESTION 2 The following are the statements of financial position as at 31 December 2019 Keris RM'000 Tombak RM'000 Meriam RM'000 Ordinary share capital 14400 8000 1280 Retained profit 480 576 400 Profit for the year 960 512 1120 Dividend paid (160) Loan from tombak 320 Overdraft 160 288 Traade payables 560 192 160 16560 9568 3120 Land 1280 3360 1424 Building 2880 3200 960 Plant and machinery 3440 1440 512 Investment in tombak 7200 Investment in Meriam 1600 Loan...

QUESTION 2 [25 MARKS] The following is a statement of Financial Position of a Company X...

QUESTION 2 [25 MARKS] The following is a statement of Financial Position of a Company X as at 31 December: P ASSETS Non-Current Assets Land and Buildings 120,000 Plant And Machinery 250,000 Total Non-Current Assets 370,000 Current Assets Stock 170,000 Debtors 90,000 Cash At Bank 30,000 290,000 Total Assets 660,000 EQUITY & LIABILITIES Equity Share Capital 260,000 Retained Earnings 20,000 280,000 Long Term Liabilities 20% Debentures 300,000 Current Liabilities Sundry Creditors 80,000 Total Equity & Liabilities 660,000 Additional Information: ...

Subjects