User Account

All Pages

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         

  1. 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.).
  2. 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

Reviews

Write a Review

Finance Basics Questions & Answers

  Prepare and interpret a cash budget for the months of may

he firm has a cash balance of $5,000 on May 1 and wishes to maintain a minimum cash balance of $5,000. Given the following data, prepare and interpret a cash budget for the months of May, June, and July. The firm makes 20% of sales for cash, 60% are ..

  Which plan is less costly

Interest cost Fixed cost financing $ Variable short-term financing $ (b) Which plan is less costly? Short-term plan Fixed cost plan.

  Estimate the expected real rate of return

Estimate the expected real rate of return on the ten- year U. S. Treasury bond. If the real rate of return is expected to be the same for the thirty- year bond as for the ten- year bond, estimate the average annual inflation rate expected by invest..

  What is the value of the stock

A stock will pay dividends of $1.0, $4.0, and $8.0 over the next three years, and then increase dividends at a rate of 7.0% afterwards. Its required rate of return is 19.0%. What is the value of the stock? Round to the penny.

  What is integration as it applies to securities offerings

What is integration as it applies to securities offerings and why does it matter?

  What is the net profitability in dollars

An insurance company collected $3.6 million in premiums and disbursed $1.96 million in losses. Loss adjustment expenses amounted to 6.6 percent.

  What is the yeild to maturity at the time of purchase

Assume par value of 1000. Assume semiannual compounding periods. What is the yeild to maturity at the time of purchase?

  There are no universally accepted definitions of financial

there are no universally accepted definitions of financial ratios but five of the following ratios are clearly

  What is meant by the utopia discount process

What is meant by the utopia discount process? Describe how expected present value is calculated.

  Calculate the amount for her and explain the account

Annie's mortgage statement shows a total payment of $699.12 with $604.60 paid toward principal and interest and $94.52 paid for taxes and insurance. Taxes and insurance for 3 months were collected at closing. Now after 6 months of payments, she..

  What is the initial cash outflow

The new machine will require that the firm purchase some additional inventory which will result in an increase in net working capital of $50,000. What is the initial cash outflow?

  Picking out the latest apparel to be sold in stores

A vendor from whom you order regularly sends you tickets to the Bears game. They are front row on the 50 yard line.

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

Submit Assignment

Academics

Major Subjects

Majors

Get In Touch

whatsapp: +1-415-670-9521

Phone: +1-415-670-9521

Email: [email protected]

TERMS & POLICIES

HELP & SUPPORT

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd