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

A square column foundation has to carry a gross allowable load of 2005 kN (FS = 3). Given: D₤ = 1.7 m, y = 15.9 kN/m³, 0' = 34°, and c' = 0. Use Terzaghi's equation to determine the size of the foundation (B). Assume general shear failure. For o' = 34°, N₁ 36.5 and Ny = 38.04. (Enter your answer to three significant figures.) B=2.16 m

For the design of a shallow foundation, given the following: Soil: ' = 20° c=57 kN/m² Unit weight, y=18 kN/m³ Modulus of elasticity, E, = 1400 kN/m² Poisson's ratio, μs = 0.35 Foundation: L=2m B=1m D₁ =1m Calculate the ultimate bearing capacity. Use the equation: 1 qu= c'Ne Fes Fed Fec +qNqFqs FqdFqc + - BNF √s F√d F 2 For d'=20°, N = 14.83, N = 6.4, and N., = 5.39. (Enter your answer to three significant figures.) qu kN/m²

1.0 m (Eccentricity in one direction only) = 0.15 m Qall = 0 1.5 m x 1.5 m Centerline An eccentrically loaded foundation is shown in the figure above. Use FS of 4 and determine the maximum allowable load that the foundation can carry if y = 16 kN/m³ and ' = 35°. Use Meyerhof's effective area method. For o' = 35°, N₁ = 33.30 and Ny = 48.03. (Enter your answer to three significant figures.) Qall kN

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