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

Question

1 Approved Answer

Can you show how to calculate in excel? An investment will pay you $65,000 in 10 years. If the appropriate discount rate is 7 percent

Can you show how to calculate in excel?

image text in transcribed

An investment will pay you $65,000 in 10 years. If the appropriate discount rate is 7 percent compounded daily, what is the present value? Future value of investment Number of years Discount rate Times compounded per year 65,000 10 7% 365 Complete the following analysis. Do not hard code values in your calculations. Your answer should be positive. Present value of investment An investment will pay you $65,000 in 10 years. If the appropriate discount rate is 7 percent compounded daily, what is the present value? Future value of investment Number of years Discount rate Times compounded per year 65,000 10 7% 365 Complete the following analysis. Do not hard code values in your calculations. Your answer should be positive. Present value of investment

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

Financial management theory and practice

Financial management theory and practice

Authors: Eugene F. Brigham and Michael C. Ehrhardt

12th Edition

978-0030243998, 30243998, 324422695, 978-0324422696

More Books

Students also viewed these Finance questions

Question

★★★★★
Show that the linear system obtained by adding a multiple of an equation in (2) to another equation is equivalent to (2).

Answered: 1 week ago

Question

★★★★★
Barrick Gold Corporation is a Canadian company with its head office in Toronto, Ontario. It mines gold and precious metals around the world. Barricks shares trade on the New York and Toronto stock...

Answered: 1 week ago

Question

★★★★★
Reread the guidelines for feedback in Chapter 2 and give each other coaching feedback.

Answered: 1 week ago

Question

★★★★★
On December 31, 2010, Dow Steel Corporation had 600,000 shares of common stock and 300,000 shares of 8%, noncumulative, nonconvertible preferred stock issued and outstanding. Dow issued a 4% common...

Answered: 1 week ago

Question

★★★★★
Can you show how to calculate in excel? An investment will pay you $65,000 in 10 years. If the appropriate discount rate is 7 percent compounded daily, what is the present value? Future value of...

Answered: 1 week ago

Question

★★★★★
Cash flow investment decision Personal Finance Problem Tom Alexander has an opportunity to purchase any of the investments shown in the following table, The purchase price, the amount of the single...

Answered: 1 week ago

Question

★★★★★
Abigail has three children - Ben who is a toddler aged 2, Marie who is aged 8, and a 15 year old named Josh. Abigail lives in a deteriorating two bedroom apartment in a crime ridden part of town. She...

Answered: 1 week ago

Question

★★★★★
As part of its internal analysis, an HR manager at a consumer products firm is asked to prepare a forecast for the supply of product managers over the next year. Which of these techniques would...

Answered: 1 week ago

Question

★★★★★
Huntington Boards manufactures two models of surfboards, Basic and Competition, in a facility in Southern California. In fabrication, machine setup costs are driven by the number of setups, machine...

Answered: 1 week ago

Question

★★★★★
Mary Ann bought a new computer for $2,000 and financed the entire purchase price at a nominal rate of interest payable 12 times per year at 9% per annum. She repaid her loan in 4 years with 48 equal...

Answered: 1 week ago

Question

★★★★★
1 2 Chang Corporation sells products for $120 each that have variable costs of $80 per unit. Chang's 3 annual fixed cost is $720,000. $120 $80 $720,000 4 Required Use the per-unit contribution margin...

Answered: 1 week ago

Question

★★★★★
Were the processes in place to recall, revisit, and reinforce the mission effective?

Answered: 1 week ago

Question

★★★★★
What evidence exists to demonstrate the school is living by the mission?

Answered: 1 week ago

Question

★★★★★
Has time been designated in the schedule for collaboration?

Answered: 1 week ago

Previous Question Next Question