FREE Trial
Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

What is the present value of a five-year $20,000 ordinary annuity plus of a lump sum of $110,000 at the end of year 5. Discount

What is the present value of a five-year $20,000 ordinary annuity plus of a lump sum of $110,000 at the end of year 5.

Discount rate of 12%

Can you please show me how to do this in excel instead? Thank you!

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access with AI-Powered Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Students also viewed these Finance questions

Question

3. If a continuous predictor variable has an odds-ratio of 1.4 in a logistic regression model, this implies that for every unit increase in the predictor: a) The probability of the outcome increases...

Answered: 1 week ago

Question

★★★★★
Preparing an Income Statement, Statement of Retained Earnings, and Balance Sheet Assume that you are the president of Gaslight Company. At the end of the first year (December 31, 2011) of operations,...

Answered: 1 week ago

Question

★★★★★
While systems can generate information from data, what advantages does a manager have as a human in evaluating the information?

Answered: 1 week ago

Question

★★★★★
i want a simple 4 bar chain mechanism model and simulation on MSC adams and do its analytical calculation and model validation just foe general explanation

Answered: 1 week ago

Question

★★★★★
Project Assignment 1 For this week we will log into the Planview Daptiv PPM tool, familiarize ourselves with navigating within the tool, and begin building out a project. We will take the fictious...

Answered: 1 week ago

Question

★★★★★
A person is creating small parts for a project. The work is boring but necessary. His boss hopes to speed up this activity by hiring another skilled employee, and in doing SO Will: Elevate the...

Answered: 1 week ago

Question

★★★★★
Mr. Vinayak is working as Chief Personnel Officer in Bank of Maharashtra. The following are the particulars of his income : Basic salary Rs.25000 p.m DA Rs.4000 p.m Special Executive allowance -...

Answered: 1 week ago

Question

★★★★★
Mr. Cruz has been working on a research related to job satisfaction of different employees from different departments. Since the company has hundreds of employees in total the number of employees per...

Answered: 1 week ago

Question

★★★★★
a. Suppose, as a result of various dynamic factors associated with exposure to international competition, Albania's economy grew, and is now represented by the rightmost production possibility...

Answered: 1 week ago

Previous Question Next Question