Answered step by step

Verified Expert Solution

Link Copied!

Question

1 Approved Answer

Posted on Jul 28, 2024

How to use Excel finance function to solve the following question? I expect to receive an income of $1,259.71 at the end of 3 years

How to use Excel finance function to solve the following question?

I expect to receive an income of $1,259.71 at the end of 3 years from now. If the discount rate is 8.00% what is the present value of this income?

A. $1,586.87

B. $1,259.71

C. $1,000.00

D. None of the above

please show the function and explain it step by step

Step by Step Solution

There are 3 Steps involved in it

Step: 1

Get Instant Access to Expert-Tailored Solutions

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

Step: 2

Step: 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

Global Corporate Finance A Focused Approach

Authors: Kenneth A. Kim

1st Edition

9814335827, 9789814335829

More Books

Students also viewed these Finance questions

Question

★★★★★

Design or modify the PREVENTIVE MAINTENANCE REPORT. Refer to the repository entry for the data flow for the elements. This report shows which computers need to have preventive maintenance performed...

Answered: 1 week ago

Question

★★★★★

Under what circumstances might a business wish to avoid paying a dividend?

Answered: 1 week ago

Question

★★★★★

Am I surfing to avoid feelings of loneliness, stress, or a nger?

Answered: 1 week ago

Question

★★★★★

Your cousin Vinnie owns a painting company with fixed costs of $200 and the following schedule for variable costs: Quantity of houses painted per month: 1 2 3 4 5 6 7 8 Variable costs: $10, $20, $40,...

Answered: 1 week ago

Question

★★★★★

to-volatility ratio of the best feasible CAL? 10. What is the ratio 11. Suppose now that your portfolio must yield an (LO 6-3) expected return of 15% and be efficient, that is, on the best feasible...

Answered: 1 week ago

Question

★★★★★

Potaw Company reported the following data at the end of 2014: Sales revenue (70% on credit) $ 460,000 Expenses (27% on credit) 76,000 Accounts receivable, net at December 31, 2014 (a decrease of...

Answered: 1 week ago

Question

★★★★★

An Aluminum alloy die casting weighs 0.63 kg and the weight of the connected gating system = 0.25 kg. Hourly production rate of the die casting operation = 80 pcs/hr. The unit heating and pouring...

Answered: 1 week ago

Question

★★★★★

[Discrete Random Variables] According to an agreement between a smartphone producer and a retail company, the former delivers a large batch of smartphones of some given model. The retail company...

Answered: 1 week ago

Question

★★★★★

The trial balance before adjustment of Cyncrewd Inc. shows the following balances: Accounts receivable Allowance for doubtful accounts (AFDA) Credit sales Sales returns Dr. $225,000 Cr. 2,340 375,000...

Answered: 1 week ago

Question

★★★★★

1. What are some issues that you must consider when determining an appropriate sample size for your project? 2. When would a sample not be large enough? 3. Can a sample be too large? 4. How would you...

Answered: 1 week ago

Question

★★★★★

assume strands is a hair salon, provides cuts, perms, ect... annual fixed cost are $ 150,000 and variable cost are 40% of sales revenue. Last year sales revenue total $ 300,000. a- determine...

Answered: 1 week ago

Question

★★★★★

=+Write a convincing :60 radio spot and a :30 TV spot for Lavakan Automatic Dog Wash or any other perfect pooch automatic doggie wash. You can use any technique like product demonstration,...

Answered: 1 week ago

Question

★★★★★

=+Here are a few familiar examples, in addition to the abovementioned ones: milk mustache (California Milk Processor Board), Clydesdales and Dalmatians (Budweiser), cool guy versus geek (Apple), the...

Answered: 1 week ago

Question

★★★★★

=+Go to these and other websites for more information about Jones soda: http://www.jonessoda.com/ and http://en.wikipedia.org/wiki/Jones_Soda_flavor_list.

Answered: 1 week ago

Previous Question Next Question