Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Can someone explain what formulas to use on excel? I am inputting these numbers and am not getting the correct answers for some reaons. the

Can someone explain what formulas to use on excel? I am inputting these numbers and am not getting the correct answers for some reaons. the Excel function is used to answer each question.
=FV(.0725,18,0,27,600)= $97,288.27
=PV(.085,3,0,206,500)= $161,670.52
=FV(.0975/4,4*4,6,300,0,0)= $121,499.84
=PV(.065/12,6*12,1,060,0,0)= $63,057.97
=FV(.045/2,12*2,25,200,0,1)= $808,243.88
=PV(.05/12,3*12,3,800,0,1)= $127,317.96

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

Students also viewed these Databases questions

Question

1. Explain why evaluation is important.

Answered: 1 week ago

Question

What are the determinants of cash cycle ? Explain

Answered: 1 week ago