Present value is calculated using the PV function as:-
=PV(rate,nper,pmt,fv,1)
=PV(12%/4,7*4,-160,,1)
=3092.33
A customer will pay $160 per quarter at the beginning of each quarter to her Internet...
A customer will pay $35 per month at the beginning of each month to her Internet provider for the next 8 years. Determine the net present value of these payments if the annual discount rate is 16%.
Beginning one month from now, a customer will pay his Internet
provider $25 per month for the next five years. Assuming all
revenue for a year is received at the middle of a year, estimate
the NPV of these revenues. Use r =0.15.
USE EXCEL
Consider the following set of cash flows over a four-year period. Determine the NPV of these cash flows, if r 0.15 and cash flows occur at the end of the year Year 1 4 $600...
3. A student pays 87.50 per quarter for insurance. What would the pay- ments be if they were made annually? Monthly? Weekly? Every two years? Annual interest is 18% compounded monthly. 4. A bank customer deposits $100 at the end of every quarter for 5 years. He then increases the deposit to $120 and continues to make quarterly payments for 6 more years. Assuming an effective rate of 8% per annum, how much is in account after 5 years? After...
please show work
Customer Lifetime Value (CLV) 1. An internet service provider (ISP) charges $19.95 per month. With an average of marketing spending of $6 per year for each customer, it's estimated that each month about 2% of customers leave ISP. Other variable costs are about $1.50 per account per month. The average upfront cost to acquire a customer is $34. What's the CLV of a customer at a discount rate of 5%? I 2. A credit card company has...
11-16 I need help quick
9. You are offered an annuity that will pay $24,000 per year for 11 years (the first payment will occur one year from today). If you feel that the appropriate discount rate is 13%, what is the annuity worth to you today? AnnPay - 24,000 DR = 13 S 134PMT -24,00 world tried It Yrs 86-59 CK NO 1 FV-O Current value of annuity in 136,486.59 10. If you deposit $16,000 per year for 12...
Juliet will lease machinery for her business with a cost of capital of 13% per quarter. Her quarterly payments are: $9,000 today, $6,000 in 3 months, $3,000 in 6 months, and $1,500 in 9 months. Her tax rate is 50%. What is the present value of her post-tax lease payments?
A 40 year annuity-due will pay 10 in each of the first 4 years, 9 in each of the next 4 years, etc., until payments of 1 are made in each of the last 4 years. The present value of the annuity payments at an annual effective rate of 5% is X. Determine X.
You are valuing an investment that will pay you $25,000 per year for the first 5 years, $35,000 per year for the next 10 years, $74,000 per year the next 16 years, and $66,000 per year for the following 10 years (all payments are at the end of each year). If the appropriate annual discount rate is 6.00%, what is the value of the investment to you today? $2,581,510.80 $536,471.26 $2,319,000.00 $1,613,487.29 $689,640.39
An investor is considering purchasing a financial security that promises to pay $653 per year for the next 3 years, then $2,268 per year for the next 2 years after that. If the investor thinks the appropriate discount rate is 7.2 percent for investments that have this level of risk, what would be the present value of those five payments today?
We Pay Insurance Co. will pay you $1,450 each quarter for 27 years. You want to earn a minimum interest rate of .99 percent per quarter. What is the most you are willing to pay today for these payments? $95,420.38 $91,124.72 $277,956.49 $92,723.40 $95,920.76