Reference no: EM13899387
I would like to have the solution to the following sample problems in EXCEL format so that I can see the formulas used. Thanks
1. What is the present value of a series of payments received each year for 9 years, starting with $300 paid one year from now and the payment growing in each subsequent year by 3%? Assume a discount rate of 5%.
Please round your answer to the nearest cent.
2. What is the present value of a series of payments received each year for 6 years, starting with $500 paid one year from now and the payment growing in each subsequent year by 5%? Assume a discount rate of 8%.
Please round your answer to the nearest cent.
3. What is the present value of a series of payments received each year forever, starting with $100 paid one year from now and the payment growing in each subsequent year by 6%? Assume a discount rate of 9%.
Please round your answer to the nearest cent.
4. What is the present value of a series of payments received each year forever, starting with $400 paid one year from now and the payment growing in each subsequent year by 9%? Assume a discount rate of 11%.
Please round your answer to the nearest cent.
|
Identify the inferential statistical tests used
: identify the inferential statistical tests used
|
|
Determine what decisions impact the allocating of resources
: Do some research regarding your local law enforcement organization. Determine what decisions impact the allocating of resources that it needs to function as a public service entity.
|
|
How should mncs choose the product line to launch
: How should MNCs choose the product line to launch it into the global market? In a short essay, describe two factors that MNCs should consider for making the choice, and discuss how it is related to the internationalization process of the MNCs.
|
|
Analyze and discuss small business growth
: In this paper, students will analyze and discuss small business growth in terms of growth strategy, business forms, short and medium term goals, financing assistance, organizational structure and staffing needs, customers and promotion, and ethics an..
|
|
What is the present value of a series of payments received
: What is the present value of a series of payments received each year forever, starting with $400 paid one year from now and the payment growing in each subsequent year by 9%? Assume a discount rate of 11%.
|
|
What fraction of the sky have the constellations moved
: Naked Eye Observing Project- What fraction of the year is the interval between your two observations (for example, 3 months is 1/4th of a year)? Approximately what fraction of the sky have the constellations moved across
|
|
What is equivalent monetary amount in terms of present worth
: What is the equivalent monetary amount in terms of present worth? Show the appropriate variable values, and then solve using the current monetary value formula.
|
|
What is the current value of a zero-coupon bond
: What is the current value of a $1,000 bond with a 5% annual coupon rate (paid semi-annually) that matures in 6 years if the appropriate stated annual discount rate is 8%.
|
|
What amount of time is necessary to realize given situation
: I anticipate having the amount of $4,000.00 after an unknown period of time. The monetary present worth is $2,357.35. The rate is 4.7%. What amount of time is necessary to realize this situation?
|