a use excel of a financial calculator to


a)  Use excel of a financial calculator to estimate the IRR of the following business opportunity:  Initial cost of $100,000, expected pre-tax annual cash flows of $54,000 for the next 7 years, and a 20% small business tax rate.  There are no assets to depreciate but there is a yearly $25,000 pre-tax opportunity cost which recognizes the time you spend operating the business.

b)  For this type of risky investment, you would normally require at least a 16% rate of return to compensate for the business risk alone.  Assuming however that you can access a line of credit with a fixed rate of 6%, what is the minimum amount of debt capital ($$) that you would have borrow before the project becomes profitable to finance?

c)  What is the most important difference between the NPV and IRR methodologies?  Discuss briefly whether or not you feel that distinction would be important to this particular case.

 

 

Request for Solution File

Ask an Expert for Answer!!
Corporate Finance: a use excel of a financial calculator to
Reference No:- TGS0206367

Expected delivery within 24 Hours