In excel create a cash flow table

Reference no: EM13698249

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: EM13698249

Questions Cloud

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. After 2 years service the company, having surplus profits, r..

What is the bond angle and molecular geometry : What is the bond angle and molecular geometry around the middle two carbon atoms of cis-2-butene?

Natural monopoly as 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.

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.

In excel create a cash flow table : 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 ..

Calculate the ph before addition of any koh : a) Calculate the pH before addition of any KOH.b) Calculate the pH after the addition of 3.43, 8.59 and 16.17 mL of the base.(Show your work in detail for one of the volumes.)

One of the great upcoming sports in the olympics : One of the great upcoming sports in the Olympics is the sport of curling. Write a brief essay on the uses of momentum collisions in curling. Be sure to discuss the importance of massive stones and of going last.

What is the business problem or opportunity : Business Decision Making Project - What is the Business Problem or Opportunity

What characteristics of the industry make it a monopoly : Describe an example of a real-world industry or market that would be considered by economists to be a natural monopoly. What characteristics of the industry make it a monopoly? What is the impact of the monopoly power on its customers?

User Account

All Pages