- +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

1961653

Questions

Asked

3,689

Active Tutors

1431570

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 : A young couple is purchasing a new sport utility vehicle

a young couple is purchasing a new sport utility vehicle the price of the new vehicle is 28300 sales tax is 75 title