Resulting cash flows item notes initial cash flow

Assignment Help Financial Management

Reference no: EM13920173

A 100,000 loan agreement has payments and inputs as follows. Calculate the XNPV, XIRR, NPV and IRR of the resulting cash flows Item Notes Initial Cash Flow (PV) 10,000.00 Start Date 01-Jan-2008 Interval (Months) 6 Year One 1,000.00 Year Two 1,500.00 Year Three 2,000.00 Salvage Value (FV) 100.00 Total Periods (N) 12.00 Discount Rate % (INT) 10.00

Calculate each in excel & show your work

Reference no: EM13920173

Questions Cloud

Profit earnings per share and ratio : Kellogg recently earned of 2.52 profit earnings per share and has a P/E ratio 1.35. The dividend has been growing at 5 percent rate over the past few years if this rate continues, what would be the stock price in five years if the P//E ratio remained..

Connections between the crime and suspected perpetrator : While investigating a crime, both the organic and inorganic evidence are used so as to identify possible connections between the crime and suspected perpetrator.

Write a review on and the band played on : Write a review about the documentry Watch And the Band Played On (1983). This is an excellent documentary of the AIDS epidemic and the epidemiologic investigation that ensued.

Assume the debt is due. given that josey : Assume the debt is due. Given that Josey has $8,000 in stockholders' equity, can the company repay the creditors at this point? Why or why not?

Resulting cash flows item notes initial cash flow : A 100,000 loan agreement has payments and inputs as follows. Calculate the XNPV, XIRR, NPV and IRR of the resulting cash flows Item Notes Initial Cash Flow (PV) 10,000.00 Start Date 01-Jan-2008 Interval (Months) 6 Year One 1,000.00 Year Two 1,500.00 ..

Overall roles of the non-state participants-foreign policy : Examine the overall roles of the Non-State participants within a current event that requires a foreign policy on terrorism to be developed. Provide a rationale for your response.

Make an inductive argument stronger : 10 is less than 100; 100 is less than 1,000; consequently, 10 is less than 1,000" is an example of a Student Answer: sound deductive argument.

Develop a mobile game using any game scenario of your choice : Using the J2ME platform, develop a mobile game using any game scenario of your choice. You are required to provide the following features in your implementation: 2D implementation using sprite, game canvas and tiled layer

About the brokerage account : You have $38,063.80 in a brokerage account, and you plan to deposit an additional $3,000 at the end of every future year until your account totals $230,000. You expect to earn 14% annually on the account. How many years will it take to reach your goa..

User Account

All Pages