Cash flow table-showing-time increments-interest value

Assignment Help Business Economics

Reference no: EM13839432

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

Reference no: EM13839432

Questions Cloud

Prices of one good change while prices are held constant : Which of the following is not one of the services the Fed provides to commercial banks? If the prices of one good change while other prices are held constant,

A project that provides annual cash flows : A project that provides annual cash flows of $11,600 for 9 years costs $64,230 today. If the required return is 5 percent, the NPV for the project is $ and you would (Click to select) accept reject the project. At a discount rate of percent, you woul..

Consider the two production isoquants in the figure : Fetzer valves can be made in either China or the United States, but because labor in the United States is more skilled, on average, than labor in China, the production technologies differ. Consider the two production isoquants in the figure. Each rep..

Natural monopoly as the number of units produced increases : Identify which of the following statements is always true for a natural monopoly as the number of units produced (output) increases.

Cash flow table-showing-time increments-interest value : 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 ..

What is the amount of the equal annual end-of-year payments : An engineer borrowed $3000 from the bank, payable in six equal end-of-year payments at 8%. The bank agreed to reduce the interest on the loan if interest rates declined in the United States before the loan was fully repaid. What is the amount of the ..

Manufacturing company purchased electrical services : A manufacturing company purchased electrical services for the next 5 years to be paid for with $70,000 now. The service after 5 years will be $15,000 per year beginning with the sixth year. the electrical company considered 15% compounded annually as..

Suppose consumers level of satisfaction : Suppose a consumer's level of satisfaction is given by AB2 and he/she has a total of $10 to spend on goods A and B. If the price of A is $1 and the price of B is $2, and assuming you can only purchase whole units (not fractional) of A and B, how many..

purchasing new sport utility vehicle : A young couple is purchasing a new sport utility vehicle. The price of the new vehicle is $28,300, sales tax is 7.5%, title and registration will cost $105. The dealer is offering a special finance rate of 1.9% APR for 36 months (compounded monthly)...

User Account

All Pages