Question: Can I type in excel a formula such as this one and it solve it? If so can you show me step by step how

Can I type in excel a formula such as this one and it solve it? If so can you show me step by step how to do that?

30 / (1+9%) + 36 / (1+9%)^2 + (43.20+2311.20) / (1+9%)^3

I can type it in google and it gives me the solution but I want to do it in excel?

If not--- how do you solve this because when I break this down I am getting an answer different than what is right. What is the order I should be doing it if I cannot put this into excel?

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!

a. Calculate the yield-to-maturity (YTM) of all the bonds in the data, including those on Sep 18, 2023. Assume the Treasury security pays coupon on a semi-annual basis if the coupon rate is not zero....

How to solve it please show step by step A consumer products testing group is evaluating two competing brands of tires, Brand 1 and Brand 2. Though the two brands have been comparable in the past,...

QUESTION 3 Use the extract from the financial statements of Peter's Plumbing Services to calculate the Current Ratio and the Acid Test Ratio for PPS: Sundry Debtors Inventory Marketable Securities...

Hi can you please solve this and show step by step how to? you can do it Via Excel. Thank you again kindly. Assume you wish to evaluate the risk and return behaviors associated with various...

Please use excel solver to solve this problem...Please show step by step from beginning and not only the output.. The coach of an age group swim team needs to assign swimmers to a 200-yard medley...

Please show very step and formulas ty! A) Block 2 (mass 4 kg) is moving on 30 degrees incline surface. Coefficient of kinetic friction between block 2 and the surface is 0.4. This block is connected...

Assignment: 1. Job No. 22567 Two king sized Bed order will require material of 7 feet by 5 feet OAK wood. The wood will cost 10tk per Sqr.Feet. The labor hour those will take is 8 hours each and the...

Hello! I am having trouble in understand one particular problem on my STATS HW for this week. I am not sure what formula or steps that were taken to solve this question. A step by step answer to this...

Kindly help me solve these problems. Show step by step workings Problem 4 - Optimal production The Acme Corp produces widgets using labor (L) and capital (K) according to the production, Q = F(L, K)...

Let N = 16, r = 10, and n = 5. Using the hypergeometric probability distribution formula, find: a. P(x=5)= b. P(x1)= Can someone solve these and show step by step instructions for doing so? Thank you...

Arsenal Electronics is to construct a new $1.2 billion semiconductor plant and has selected four small towns in the Midwest as potential sites. The important decision criteria and grades for each...

evaluates the impact people in an organisation can have on a project. Specifically, you will evaluate the impact people have on the successful implementation of a project in complex, networked and...

In efficient markets, what relationship should exist between risk premiums across different investments? Risk premiums should vary irversely with market volatility. All efficient investments shoutd...

Write a function ` remove _ digits ` that will remove all digits from all elements in a * vector of strings