Question: I need help with both 7 and 8 and how do I plug it into excel. Problem 7: If the cash flows listed below were

I need help with both 7 and 8 and how do I plug it into excel.

Problem 7: If the cash flows listed below were deposited at 4.1% interest, what would the present value be? Problem 8: Find the future value of the same stream of cash flows, assuming that the firm's opportunity cost is 5.5%. NPER 5 Year NPER 4.10% 1 I/Y (Rate) I/Y (Rate) PV 5 5.50% $105,479.16 ? 2 PV Amount 22,500 23,295 23,750 24,505 25,000 PMT 0 3 PMT 0 FV 4 FV ? Compounding Periods 5 Compounding Periods CPT (Compute) ? CPT (Compute)

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!

ACCTG 231 - Spring 2021 Comprehensive Problem #2 Due, Monday, April 19th; 11:59 pm Gallatin, Inc., is deciding between investing in one of two machines in order to take on a new project. Each of the...

Managerial Accounting Comprehensive Problem #2 (need answered by Monday night 4/19) ACCTG-Spring 2021 Comprehensive Problem #2 Due, Monday, April19th, 11:59 pm Gallatin, Inc., is deciding between...

ACCTG 231 - Spring 2021 Comprehensive Problem #2 Due, Monday, April19th; 11:59 pm Gallatin, Inc., is deciding between investing in one of two machines in order to take on a new project. Each of the...

need help with 6, 7, and 8 N=10 OM Bonds Payable January 1, 2022. Excel Corporation issued 10 year, 8% bonds with a face value of $3.190,000. The bonds were sold to yield 6%. Interest is payable...

Use the following information to address the questions below. PharmPic is considering the following project with the following cash flows: PharmPic Project Period Cash Flow 0 -$50,000 1 -$7,000 2...

I am wondering if anyone has corrected solutions to fnce 300 assignments 1 2 and 3. I am concered about my answers and would love to compare. Pretty sure on my answers for 1 and 2 mainly interested...

property as collateral for a new loan she was in the process of obtaining to finance a hotel acquisition. Despite repeated assurances from various officers at First Bank of Green, no one at First...

Chapter 1 Introduction to Accounting NAME ___________________________________________________ DATE _______________________________ 1. Which of the following events would be recorded as an accounting...

Hoyt, Inc. has estimated current year sales (in millions) for the next four quarters. Q1 $240Q2 $250 Q3 $205 Q4 $350 ? Sales for the 1st quarter next year are projected to be $230.? Accounts...

In our opening story, DHX Media decided to "go public." What reasons could it have for making this decision?

Air at 35C, 105 kPa, flows in a 100 mm 150 mm rectangular duct in a heating system. The volumetric flow rate is 0.015 m3/s. What is the velocity of the air flowing in the duct and what is the mass...

Which is the investor's utility maximization problem in finding the weight on the risky asset y in the optimal complete portfolio? Multiple choice question. Max U = rf + y [ E ( rP ) rf ] ( 1 ) / ( 2...

A company issues 1,050 shares of its common stock for $33,600 cash. Prepare journal entries to record this event under each of the following separate situations.