Suppose the government implements a negative income tax plan to deal with the poverty problem. The negative income tax rate is s
1 answer:
You might be interested in
Answer:
the internal rate of return is 6%
Explanation:
The computation of the internal rate of return is shown below;
Given that
Years Cash flows
0 -$20,790
1 $6,000
2 $6,000
3 $6,000
4 $6,000
Now apply the following formula i.e..
= IRR()
After applying the above formula, the internal rate of return is 6%
Answer:
Ans. The effective annual interest rate charged on the loan is 12.99% effective annually. (Please see the attached excel spread sheet)
Explanation:
Hi, attached is the amortization table that I made for this case. Notice that there is a yellow and green cell, the yellow one is the result of using the "IRR" function of MS Excel which provides an effective monthly rate, since the payments are made every month, then we have to transform that monthly effective rate into an effective annual rate, this is the formula to use.
That is:
Which we round to 12.99% effective annually.
Finally, notice that I didnt use the payments to find the effective rate, I used the cash flow, that was because you didn´t receive all the 100K (the fee, remember?), you received $98,000.
Best of luck.