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

Question

1 Approved Answer

I need the excel formula for this please An investment will pay you $95,000 in 10 years. If the appropriate discount rate is 9 percent

image text in transcribed

I need the excel formula for this please

An investment will pay you $95,000 in 10 years. If the appropriate discount rate is 9 percent compounded daily, what is the present value? Input area: (Use cells A6 to B9 from the given information to complete this question. Your answer should be a positive value.) Output area

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_2

Step: 3

blur-text-image_3

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

Trillions How A Band Of Wall Street Renegades Invented The Index Fund And Changed Finance Forever

Trillions How A Band Of Wall Street Renegades Invented The Index Fund And Changed Finance Forever

Authors: Robin Wigglesworth

1st Edition

0593087682,0593087690

More Books

Students also viewed these Finance questions

Question

★★★★★
As the owner of a small business, explain how you would organize a strategic-information scanning system. How would you organize such a system in a large organization?

Answered: 1 week ago

Question

★★★★★
Entres for ispung Bands and Amortuing Discount by strwoht-tine Mehod bonds were issued at a mwhet (effective) imerest rate of 6%, tevulting in chin receiving cash of 320,678.652. a. Joumalde the...

Answered: 1 week ago

Question

★★★★★
6. List success factors associated with knowledge management.

Answered: 1 week ago

Question

★★★★★
URL Services has two divisions: Basic Web Pages and Custom Web Pages. Ricky Vega, manager of Custom Web Pages, wants to find out why Custom Web Pages is not profitable. He has prepared the reports...

Answered: 1 week ago

Question

★★★★★
Tyson Foods Inc A has a project with initial investment requiring $-145,000 and the following cash flows will be generated for the following 5 years at the end of each year because of the project:...

Answered: 1 week ago

Question

★★★★★
! Required information [ The following information applies to the questions displayed below. ] The stockholders' equity section of TVX Company on February 4 follows. Common stock - $ 2 0 par value, 1...

Answered: 1 week ago

Question

★★★★★
During 2024, its first year of operations, Pave Construction provides services on account of $160,000. By the end of 2024, cash collections on these accounts total $110,000. Pave estimates that 25%...

Answered: 1 week ago

Question

★★★★★
For a function for 50 guests you require 8.500 kg of trimmed lamb. Trimmings are 20 %. How much lamb do you need to order from stores? Provide your answer to 3 decimal places) Also consider the...

Answered: 1 week ago

Question

★★★★★
An investment universe of the following risky assets with a dependence structure (correlation) is given. Use the ready appropriate formulae from Portfolio Optimisation Lecture. Asset A 0.02 0.05 1...

Answered: 1 week ago

Question

★★★★★
The Richmond Company is contemplating the acquisition of a higher capacity automatic presser machine. The new machine would cost P 1,920,000 and has an estimated life of eight years with no salvage...

Answered: 1 week ago

Question

★★★★★
The Fielder manufacturing company uses job order costing system. The company uses machine hours to apply overhead cost to jobs. At the beginning of 2020, the company estimated that 7,850 machine...

Answered: 1 week ago

Previous Question Next Question