- +44 141 628 6080
- [email protected]

You have made arrangements to borrow 1000 now and another

You have made arrangements to borrow $1,000 now and another $1,000 three years from now (End of Yr 3). The obligation is to be repaid at the end of four years. If the projected interest rates in years one, two, three, and four are 10%, 12%, 12%, and 14% respectively:

a) In EXCEL create a Cash Flow Table. Showing: time increments, interest values, borrowed amounts and Lump Sum Payments.

b) How much will be repaid as a lump-sum amount at the end of four years?

Method 1: Future Worth calculations (tables in back of book or EXCEL)

Method 2: Use the EXCEL function =FVSCHEDULE

Expected delivery within 24 Hours

1940397

Questions

Asked

3,689

Active Tutors

1422386

Questions

Answered

**
Start Excelling in your courses, Ask a tutor for help and get answers for your problems !! **

Â©TutorsGlobe All rights reserved 2022-2023.

## Q : If the fed wished to defend the exchange rate of the ie

if the fed wished to defend the exchange rate of the ie prevent the exchange rate from falling what policy action