Future worth calculations

Assignment Help Business Economics

Reference no: EM13741138

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

Questions Cloud

Fetzer valves can be made in either china : 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..

The keys to success in developing stage i organization : Discuss the keys to success in developing Stage I and Stage II organizations. Provide an example of a successful company in each stage.

Analyze chapter roman house as theater of the joys of life : You are to analyze and critique the chapter by Paul Zanker entitled, "The Roman House as Theater of the Joys of Life." Roman Art, 2008.

Amendments from the bill of rights : For the Phase 4 IP, you will choose three amendments from the Bill of Rights, and discuss them. For this discussion board, you are to decide which amendment in the Bill of Rights you consider the most important today, and explain why. To support y..

Future worth calculations : 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 ..

Reduce the interest on the loan : 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.

Development through engagement in the global economy : What type of economic environment appears to be best for developing countries seeking to promote their own growth and development through engagement in the global economy?

What analytical tools can be used by the supply group : What analytical tools can be used by the supply group to determine the right price. How could Nationwide's supply department have prevented the price escalations

What is the impact of the monopoly power on its customers : 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