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

Question

1 Approved Answer

***can someone show me how to do this in excel*** A. $34,656.60 NPER B. $36,666.67 RATE C. $38,604.00 PV D. $40,020.50 PMT E. $42,141.41 FV

***can someone show me how to do this in excel***

image text in transcribed

A. $34,656.60 NPER
B. $36,666.67 RATE
C. $38,604.00 PV
D. $40,020.50 PMT
E. $42,141.41 FV
Calculating Future Values. If today is Year 0, what is the future value of the following cash flows five years from now? What is the future value 10 years from now? Assume an interest rate of 6.9 percent per year. Cash Flow $15,000 24,000 33,000 Year 2 3 5

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored 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

Recommended Textbook for

Options Trading For Beginners

Options Trading For Beginners

Authors: Mike Hartley

1st Edition

979-8864514832

More Books

Students also viewed these Finance questions

Question

Assume you are a news anchor for a television channel presenting election results from different states as well as tweets from your viewers. Would a linear or a nonlinear presentation be more...

Answered: 1 week ago

Question

★★★★★
1. Using the values listed in Table 16.1, describe the culture of Wegmans. We have listed 54 values below. These are divided into two groups of 27 each. Select four values in the YOU ARE group and...

Answered: 1 week ago

Question

★★★★★
***can someone show me how to do this in excel*** A. $34,656.60 NPER B. $36,666.67 RATE C. $38,604.00 PV D. $40,020.50 PMT E. $42,141.41 FV Calculating Future Values. If today is Year 0, what is the...

Answered: 1 week ago

Question

★★★★★
Which of the following is NOT an example of the process element of an information system Which of the following is NOT an example of the process element of an information system The security process...

Answered: 1 week ago

Question

★★★★★
5. A lozenge initially weighing 2.95 g is dissolved in 85 mL of water. Given the experimental data below, find the best fit value of k and D/h using linear regression for both the spherical and...

Answered: 1 week ago

Question

★★★★★
The first sheet on QMB3200-Homework#1Data.xlsx is named Commute Time. It lists the average commute time (in minutes) it takes citizens of 379 metropolitan areas to travel to work and back home each...

Answered: 1 week ago

Question

★★★★★
I need help figuring out the rest of my network tables before I start on configuring everything. There's a section wanting an interface, IP address, mask, and gateway for the switches and subnets. I...

Answered: 1 week ago

Question

★★★★★
At which speed is maximum power point tracking not possible anymore because vtip is limited to 70 m/s (corresponding to point C )? Hint: Divide max with the gear ratio, GR to get WTRmax . Then...

Answered: 1 week ago

Question

★★★★★
Describe some of the components of a family system and how this system may be impacted by addictions or by recovery from an addiction. Please include key terms you have learned to explain your...

Answered: 1 week ago

Question

★★★★★
=+3. If you were to consider pursuing a faith-based approach to your healing,

Answered: 1 week ago

Question

★★★★★
=+what role would you like your religion to play in your healing journey?

Answered: 1 week ago

Question

★★★★★
=+1. What does healing mean to you now?

Answered: 1 week ago

Previous Question Next Question