Using the Excel ‘Help’ menu, demonstrate the proper use of given function FV(rate,nper,pmt,pv,type) with a simple example.

Question

Want to see the full answer?

Answer 1

Question

Chapter 14, Problem 2P

(a)

To determine

Using the Excel ‘Help’ menu, demonstrate the proper use of given function FV(rate,nper,pmt,pv,type) with a simple example.

(b)

To determine

Using the Excel ‘Help’ menu, demonstrate the proper use of given function IPMT(rate,per,nper,pv,fv,type) with a simple example.

(c)

To determine

Using the Excel ‘Help’ menu, demonstrate the proper use of given function NPER(rate,pmt,pv,fv,type) with a simple example.

(d)

To determine

Using the Excel ‘Help’ menu, demonstrate the proper use of given function PV(rate,nper, pmt,fv,type) with a simple example.

Expert Solution & Answer

Want to see the full answer?

Check out a sample textbook solution

See solution

Students have asked these similar questions

An unstretchable cable with mass per unit length 5 kg/m is hanging between points A and B. The horizontal distance between A and B is 20 m. The vertical distance is 15 m (B is in a lower position). We measure a point on the cable which lies by a horizontal distance of 5 meters to point A. It is found to be 4 meters lower than point A. The shape of the cable is almost straight.Use the small sag approximation (Lecture 5) and keep the accuracy to O (e) to estimate the horizontal load H on A and B.

Q1. For the frame shown below: i. ii. iii. Identify the unknown reactions for the supports (Pin at A and F). Determine if the frame is statically determinate, if not determine the degrees of determinacy. Calculate the unknown reactions for the frames (the frame has internal pin at C) Pin D 25kN 30° 30° 30° 30 B 40kN 60° 16m 60°

Q2. For the beams shown below: i. ii. iii. iv. Sketch the deflected shape Determine the reactions at the supports Calculate and sketch the distribution of the shear force and the bending moment Locate the max moment and POC locations (Note: all dimensions are in meters) 15kN/m 6kN/m 30 KN 30 A B Pin D 5.0 1.0 2.0 3.0

Answer 2

Question

Chapter 14, Problem 2P

(a)

To determine

Using the Excel ‘Help’ menu, demonstrate the proper use of given function FV(rate,nper,pmt,pv,type) with a simple example.

(b)

To determine

Using the Excel ‘Help’ menu, demonstrate the proper use of given function IPMT(rate,per,nper,pv,fv,type) with a simple example.

(c)

To determine

Using the Excel ‘Help’ menu, demonstrate the proper use of given function NPER(rate,pmt,pv,fv,type) with a simple example.

(d)

To determine

Using the Excel ‘Help’ menu, demonstrate the proper use of given function PV(rate,nper, pmt,fv,type) with a simple example.

Expert Solution & Answer

Want to see the full answer?

Check out a sample textbook solution

See solution

Answer 3

Question

Chapter 14, Problem 2P

(a)

To determine

Using the Excel ‘Help’ menu, demonstrate the proper use of given function FV(rate,nper,pmt,pv,type) with a simple example.

(b)

To determine

Using the Excel ‘Help’ menu, demonstrate the proper use of given function IPMT(rate,per,nper,pv,fv,type) with a simple example.

(c)

To determine

Using the Excel ‘Help’ menu, demonstrate the proper use of given function NPER(rate,pmt,pv,fv,type) with a simple example.

(d)

To determine

Using the Excel ‘Help’ menu, demonstrate the proper use of given function PV(rate,nper, pmt,fv,type) with a simple example.

Expert Solution & Answer

Want to see the full answer?

Check out a sample textbook solution

See solution

Answer 4

Question

Chapter 14, Problem 2P

(a)

To determine

Using the Excel ‘Help’ menu, demonstrate the proper use of given function FV(rate,nper,pmt,pv,type) with a simple example.

(b)

To determine

Using the Excel ‘Help’ menu, demonstrate the proper use of given function IPMT(rate,per,nper,pv,fv,type) with a simple example.

(c)

To determine

Using the Excel ‘Help’ menu, demonstrate the proper use of given function NPER(rate,pmt,pv,fv,type) with a simple example.

(d)

To determine

Using the Excel ‘Help’ menu, demonstrate the proper use of given function PV(rate,nper, pmt,fv,type) with a simple example.

Expert Solution & Answer

Want to see the full answer?

Check out a sample textbook solution

See solution

Answer 5

Chapter 14, Problem 2P

(a)

To determine

Using the Excel ‘Help’ menu, demonstrate the proper use of given function FV(rate,nper,pmt,pv,type) with a simple example.

(b)

To determine

Using the Excel ‘Help’ menu, demonstrate the proper use of given function IPMT(rate,per,nper,pv,fv,type) with a simple example.

(c)

To determine

Using the Excel ‘Help’ menu, demonstrate the proper use of given function NPER(rate,pmt,pv,fv,type) with a simple example.

(d)

To determine

Using the Excel ‘Help’ menu, demonstrate the proper use of given function PV(rate,nper, pmt,fv,type) with a simple example.

Answer 6

Chapter 14, Problem 2P

(a)

To determine

Using the Excel ‘Help’ menu, demonstrate the proper use of given function FV(rate,nper,pmt,pv,type) with a simple example.

Answer 7

Chapter 14, Problem 2P

(a)

To determine

Using the Excel ‘Help’ menu, demonstrate the proper use of given function FV(rate,nper,pmt,pv,type) with a simple example.

Answer 8

(b)

To determine

Using the Excel ‘Help’ menu, demonstrate the proper use of given function IPMT(rate,per,nper,pv,fv,type) with a simple example.

Answer 9

(b)

To determine

Using the Excel ‘Help’ menu, demonstrate the proper use of given function IPMT(rate,per,nper,pv,fv,type) with a simple example.

Answer 10

(c)

To determine

Using the Excel ‘Help’ menu, demonstrate the proper use of given function NPER(rate,pmt,pv,fv,type) with a simple example.

Answer 11

(c)

To determine

Using the Excel ‘Help’ menu, demonstrate the proper use of given function NPER(rate,pmt,pv,fv,type) with a simple example.

Answer 12

(d)

To determine

Using the Excel ‘Help’ menu, demonstrate the proper use of given function PV(rate,nper, pmt,fv,type) with a simple example.

Answer 13

(d)

To determine

Using the Excel ‘Help’ menu, demonstrate the proper use of given function PV(rate,nper, pmt,fv,type) with a simple example.

Answer 14

Expert Solution & Answer

Answer 15

Expert Solution & Answer

Answer 16

Want to see the full answer?

Check out a sample textbook solution

See solution

Answer 17

Ch. 14.2 - Prob. 1BYG Ch. 14.2 - Prob. 2BYG Ch. 14.2 - Prob. 3BYG Ch. 14.2 - Prob. 4BYG Ch. 14.2 - Prob. 5BYG Ch. 14.2 - Prob. BYGV Ch. 14.4 - Prob. 1BYG Ch. 14.4 - Prob. 2BYG Ch. 14.4 - Prob. 3BYG Ch. 14.4 - Prob. 4BYG

Using the Excel ‘Help’ menu, demonstrate the proper use of given function FV(rate,nper,pmt,pv,type) with a simple example.

Solution Summary: The author demonstrates the proper use of given function FV with a simple example.

Concept explainers

Using the Excel ‘Help’ menu, demonstrate the proper use of given function FV(rate,nper,pmt,pv,type) with a simple example.

Using the Excel ‘Help’ menu, demonstrate the proper use of given function IPMT(rate,per,nper,pv,fv,type) with a simple example.

Using the Excel ‘Help’ menu, demonstrate the proper use of given function NPER(rate,pmt,pv,fv,type) with a simple example.

Using the Excel ‘Help’ menu, demonstrate the proper use of given function PV(rate,nper, pmt,fv,type) with a simple example.

Want to see the full answer?

Chapter 14 Solutions