Home / Expert Answers / Finance / calculate-using-present-value-tables-calculate-using-excel-and-the-present-value-tables-you-have-pa562

(Solved): Calculate using Present Value Tables. Calculate using excel and the Present value tables You have \( ...


Calculate using Present Value Tables.
You have \( \$ 100000 \) available to invest for a period of 5 years. After investigating the local bank, you have complied t

Calculate using excel and the Present value tables

Question 1 You have \( \$ 100000 \) available to invest for a period of 5 years. After investigating the local bank, you have
2. Calculate using the Present Value Tables.
You have \( \$ 100000 \) available to invest for a period of 5 years. After investigating the local bank, you have complied the following table for comparison. Question 1 You have \( \$ 100000 \) available to invest for a period of 5 years. After investigating the local bank, you have complied the following table for comparison. Students are required to: 1. Calculate using excel; and (10 marks) 2. Calculate using the Present Value Tables.


We have an Answer from Expert

View Expert Answer

Expert Answer

CIBC Bank PV = Amount available = $100,000 n = 5*4 = 20 Quarters r = Quarterly interest rate = 8%/4 = 2% Future value = PV*(1+r)^n Future
We have an Answer from Expert

Buy This Answer $5

Place Order

We Provide Services Across The Globe

Order Now
Go To Answered Questions