Question

In: Finance

A company will invest with an initial investment of $1,000,000. Assuming a market interest rate of...

A company will invest with an initial investment of $1,000,000. Assuming a market interest rate of 5% and cash flow for 5 years is expected in the table below:

Year Cash Flow
1 425,000
2 384,000
3 321,500
4 282,500
5 200,000

Calculate the PAYBACK PERIOD and NPV!

Solutions

Expert Solution

Payback period= full years until recovery + unrecovered cost at the start of the year/cash flow during the year

                             = 2 years + ($1,000,000 - $809,000)/ $321,500

                             = 2 years + $191,000/ $321,500

                             = 2 years + 0.5941

                             = 2.59 years.

Net present value is solved here using a financial calculator. The steps to solve on the financial calculator:

  • Press the CF button.
  • CF0= -$1,000,000. It is entered with a negative sign since it is a cash outflow.
  • Cash flow for all the years should be entered.
  • Press Enter and down arrow after inputting each cash flow.
  • After entering the last cash flow, press the NPV button and enter the market interest rate of 5%.
  • Press the down arrow and CPT buttons to get the net present value.

The net present value is $419,903.69.

In case of any query, kindly comment on the solution.


Related Solutions

assuming the stated rate of interest and the market rate of interest are different, the value...
assuming the stated rate of interest and the market rate of interest are different, the value of a bond is equal to the? A face amount of the bond B present value of the interest payments and the principal payment, based on the market interest rate. C present value of the interest payments and the principal payment, based on the stated interest rate D none of the above   
Interest Rate Parity (invest here, or invest there) China investment rate for 1 year = 7%...
Interest Rate Parity (invest here, or invest there) China investment rate for 1 year = 7% Japan investment rate for 1 year = 1% Spot quote = 16.10 -11 CNYJPY (6 character coding, NOT fraction) 1 year forward quote = 15.40 02 CNYJPY Use the data above to determine if covered interest arbitrage is possible. Basically, you’ll do 4 math problems. Should China invest at home, or convert and invest in Japan? Should Japan invest at home, or convert and...
A company issues $1,000,000 of 20-year 10% bonds that pay interest semiannually. The market rate for...
A company issues $1,000,000 of 20-year 10% bonds that pay interest semiannually. The market rate for bonds of similar risk is 9%. Prepare the journal entries to record the issuance of the bond and the first two interest payments. : Please walk through interest journal entries
ABC Company sold $1,000,000 of 5% bonds with interest due semi-annually at a market rate of...
ABC Company sold $1,000,000 of 5% bonds with interest due semi-annually at a market rate of 6%. They are 5 year bonds. This sale occurred January 1, 2019. a. Provide an amortization schedule using the effective interest rate method for the entire life of the bond. b. Show the journal entry for the January sale. c. Show the journal entry for the first interest payment date. NOTE: A good search term for finding examples is "effective interest rate method example"...
XYZ Company will invest with an initial investment of $ 1 million. The assumption of a...
XYZ Company will invest with an initial investment of $ 1 million. The assumption of a market interest rate of 5% and cash flow for 5 years is expected as in the table below: year Cash Flow 1 425.000 2 384.000 3 321.500 4 282.500 5 200.000 Calculate the payback period and Net Present Value (NPV)
An investment with an initial deposit of $12,993 is growing at an interest rate of 3.22%...
An investment with an initial deposit of $12,993 is growing at an interest rate of 3.22% compounded quarterly. Round all answers to two decimal places if necessary. 1. Find the accumulated amount of the investment at the end of 3 years. 2. The interest rate changes to 4.85% compounded monthly after the first 3 years. Calculate the accumulated amount in this investment at the end of year 6. 3. Find the total amount of interest accumulated during the entire 6...
An investment with an initial deposit of $7,474 is growing at an interest rate of 3.91%...
An investment with an initial deposit of $7,474 is growing at an interest rate of 3.91% compounded monthly. Round all answers to two decimal places where necessary. 1. Find the accumulated amount of the investment at the end of 3 years. P/Y = C/Y =    N =    I/Y = % PV = $   PMT = $   FV = $ 2. At the end of the 3 years, the interest rate changes to 8.52% compounded semi-annually. Calculate the accumulated amount in...
The internal rate of return represents the rate of interest that recovers the initial investment outlay....
The internal rate of return represents the rate of interest that recovers the initial investment outlay. Discuss the validity of this statement. paragraph answer:
Your company has a $1,000,000. loan for a new assembly station. The interest rate for this...
Your company has a $1,000,000. loan for a new assembly station. The interest rate for this loan is 7% compounded annually. Your company will make $100,000 payment at the end of each year, starting the end of the first year. By calculation, your company will make 18 annual payments. Payments for Year-1 through Year-17 are the same at $100,000. Payment for the last Year-18 will be less than $100,000. To payback this loan of 1M based on this payment plan,...
Interest rate on an investment
Ken Francis is offered the possibility of investing $2,745 today; in return, he would receive $10,000 after 15 years. What is the annual rate of interest for this investment? (PV of $1, FV of $1, PVA of $1, and FVA of $1) (Use appropriate factor(s) from the tables provided. Round your "PV of a single amount" to 4 decimal places and percentage answer to the nearest whole number.)Present Value/Future Value=p (PV of a Single Amount)Interest Rate/
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT