The rate must agree to the period of cash flows

Assignment Help Financial Management

Reference no: EM131887516

Prepare an Excel model that will produce the following:

The net present value of a ten-year payment stream of $10,000 per month at 3% (assume the first payment is 30 days away)

An amortization table of the payment stream showing the allocation of each monthly payment to interest and principal

Make sure the following input variables can be changed:

Monthly payment amount

Interest rate

USING EXCEL TO CALCULATE NPV

Things to remember:

Excel assumes the first payment is one period away

Formula =NPV(RATE,Cell_Range) =NPV(4%,A1…A12)

If the first payment (Cell A1) is received on day 1, the formula should be: =A1+NPV(4%,A2…A12)

The rate must agree to the period of cash flows. Monthly payments using an annual rate of 4% should be shown as follows: =NPV((4%/12),A1….A12)

Reference no: EM131887516

Questions Cloud

Describe possible networks that might be used : Explain at least two possible approaches to managing her data for easy access. Describe possible networks that might be used to support her business needs

Define marketing strategy in consumer and business markets : B2B marketing. Student can differentiate the differences in marketing strategy between consumer markets and business markets.

What is the volatility of your portfolio : What proportion should you invest in each asset? What is the volatility (standard deviation) of your portfolio?

Describe three ways we can define what is abnormal behavior : Describe three ways we can define what is abnormal behavior?

The rate must agree to the period of cash flows : The net present value of a ten-year payment stream of $10,000 per month at 3% The rate must agree to the period of cash flows.

How partnerships with families can be developed : Policies and practices regarding separation and reunion that are essential to healthy toddler growth and development.

Parenting through poverty : Find an academic research journal article(share the name of the journal) related to that topic "Parenting through poverty"

Determining the asset risk-return relationship : Having taken Finance 2660, he remembered to use the capital asset pricing model (CAPM) as a way of determining the asset’s risk-return relationship.

What is another assessment tool : What is another assessment tool that could help provide additional information for that mental health issue?

User Account

All Pages