Solution-Calculate the present value of amount

Calculate the present value of amount

Assignment Help Finance Basics

Reference no: EM131862127

This is an Excel assignment.

Time Value of Money

Assume a company has an initial cash outflow of $150,000, followed by after-tax cash inflows as follows. Assume the company's required rate of return is 10%

_0_________1_______2_______ 3_______4_______5_____

(150,000) 25,000 35,000 40,000 45,000 50,000

Using the time line shown above, calculate the Present Value of each amount (e.g., the present value of $25,000, present value of $35,000, etc.).
Using the time line shown above, calculate the Net Present Value for this project, using the Excel formula for NPV as discussed in class.

Loan Amortization

Assume you are taking out a loan for $150,000 at a nominal rate of interest of 4%, with payments to be made annually over a period of 10 years. The first payment will be made one year from now.

Set up a loan amortization schedule showing the annual payments and the amount of principal and interest for each payment. Also show the ending balance of the loan after each payment is made.

Reference no: EM131862127

Questions Cloud

Compile a list of methods to stop different cyber crimes : write a 1 to 1 ½ page paper (using APA style formatting) on methods to either catch or stop cyber criminals. Explain the different methods in detail.

Discuss how you are going to set up your results section : Discuss how you are going to set up your results section. What are the main ideas or findings that will be the main sentence for each paragraph?

Understand the different financial ratios : Why is it important for banking institutions to understand the different financial ratios and how this could impact a customer?

Discuss the disadvantages of doing research problem : Researchers often identify the research problem and then go in search of a theory. Discuss the disadvantages of doing this. What does the textbook recommend.

Calculate the present value of amount : Using the time line shown above, calculate the Present Value of each amount (e.g., the present value of $25,000, present value of $35,000, etc.).

Create a culture of innovation and change : Identify three conditions that would need to be implemented (or have already been implemented) in your organization to create a culture of innovation and change

Describe the quantitative design of the article you selected : Describe the quantitative design of the article you selected. Present the strengths and limitations of this type of design according to the textbook.

What are the possible roadblocks to recognizing bias : In any project, there is a possibility that bias will creep into either the research or the interpretation of data.

Form of an ordinary annuity : Suppose you are going to receive $17,000 per year for 5 years. The appropriate interest rate is 8 percent. a) What is the present value of the payments

User Account

All Pages

Calculate the present value of amount

Reference no: EM131862127

Reference no: EM131862127

Questions Cloud

Reviews

Write a Review

Finance Basics Questions & Answers

Financial reporting and analysis

A report on financial accounting

Describe the types of financial ratios

Differences between sole proprietorship and corporation

Prepare a cash budget statement

What are the implied interest rates

State pricing theory and no-arbitrage pricing theory

Small business administration

Effect of financial leverage

Evaluate the basis for the payment to the lender

Importance of opps, ipps, mpfs and dmepos

Time value of money

Assured A++ Grade

Academics

Major Subjects

Majors

Get In Touch

TERMS & POLICIES

HELP & SUPPORT