BuyFind*arrow_forward*

5th Edition

Saeed Moaveni

Publisher: Cengage Learning

ISBN: 9781305084766

Chapter 14, Problem 2P

Textbook Problem

288 views

In Chapter 20, we will cover engineering economics. For now, using the Excel **Help** menu, familiarize yourself with the following functions. Create a simple example and demonstrate the proper use of the function.

a. FV(rate, nper, pmt, pv, type)

b. IPMT(rate, per, nper, pv, fv, type)

c. NPER(rate, pmt, pv, fv, type)

d. PV(rate, nper. pmt, fv, type)

(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.

Open the spread sheet (excel sheet) go to file and select Help, it will displays “Microsoft office help”, now click on it, then a new pop-up displays with the name of “Excel Help”. Now in the search place Type ‘FV’ and click search it will display various syntax functions related to finance.

Now click on the function “FV function”, it will be shown the article for FV function and given excel function is,

FV(rate,nper,pmt,pv,type)

That is, returns the future value of a series of payments.

Here,

rateis refer to interest rate per period,

nper is refer to total number of payment periods in an annuity,

pmt is refer to payment made each period,

pv is refer to present value, and

type is refer to the number 0 or 1 indicating when payments are due, end or the beginning of period.

Example:

The future value of

(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.

Engineering Fundamentals: An Introduction to Engineering (MindTap Course List)

Show all chapter solutions

Ch. 14.2 - What is the difference between a workbook and a...Ch. 14.2 - What is a range?Ch. 14.2 - Explain what is meant by absolute cell reference,...Ch. 14.2 - Give example of Excels mathematical and...Ch. 14.2 - Give examples of Excels logical functions and...Ch. 14.2 - VocabularyState the meaning of the following...Ch. 14.4 - What types of charts can be created with Excel?Ch. 14.4 - What is the most common type of chart in...Ch. 14.4 - What is a matrix?Ch. 14.4 - Give examples of matrix operations that can be...

Ch. 14.4 - How do you solve a set of linear equations with...Ch. 14.4 - VocabularyState the meaning of the following...Ch. 14.5 - What is VBA?Ch. 14.5 - What is a subroutine?Ch. 14.5 - What is a macro?Ch. 14.5 - Explain what is meant by object-oriented syntax.Ch. 14.5 - VocabularyState the meaning of the following...Ch. 14 - Using the Excel Help menu, discuss how the...Ch. 14 - In Chapter 20, we will cover engineering...Ch. 14 - In Chapter 10, we discussed fluid pressure and the...Ch. 14 - As we explained in Chapter 10, viscosity is a...Ch. 14 - Using Excel, create a table that shows the...Ch. 14 - Using Excel, create a table that shows the...Ch. 14 - Using Excel, create a table that shows the...Ch. 14 - Using Excel, create a table that shows the...Ch. 14 - Using Excel, create a table that shows the...Ch. 14 - Using Excel, create a table that shows the...Ch. 14 - As we explained in Chapter 7, the air resistance...Ch. 14 - The cantilevered beam shown in the accompanying...Ch. 14 - Fins, or extended surfaces, are commonly used in a...Ch. 14 - A person by the name of Huebscher developed a...Ch. 14 - A Pitot tube is a device commonly used in a wind...Ch. 14 - Use Excel to solve Example 7.1. Recall we applied...Ch. 14 - We will discuss engineering economics in Chapter...Ch. 14 - A person by the name of Sutterland has developed a...Ch. 14 - In Chapter 11, we explained the concept of...Ch. 14 - Use the data given in Figure 14.10 and duplicate...Ch. 14 - Use Excel to plot the following data. Use two...Ch. 14 - Use Excel to plot the following data for a pump....Ch. 14 - Use the following empirical relationship to plot...Ch. 14 - Starting with a 10 cm 10 cm sheet of paper, what...Ch. 14 - Given matrices: [A]=[421707153], [B]=[121533457],...Ch. 14 - Solve the following set of equations using Excel....Ch. 14 - Solve the following set of equations using...Ch. 14 - Find the equation that best fits the following set...Ch. 14 - Find the equation that best fits the following set...Ch. 14 - Find the equation that best fits the following set...Ch. 14 - Use VBA to create a custom-made dialog box for...Ch. 14 - Use VBA to create a custom-made dialog box for...Ch. 14 - Use VBA to create a custom-made dialog box for...Ch. 14 - Use VBA to create a custom-made dialog box for...Ch. 14 - Use VBA to create a custom-made dialog box to...

Find more solutions based on key concepts

Show solutions Repeat Problem 2.2 with the following results of a sieve analysis: 2.2 Following are the results of a sieve ana...

Fundamentals of Geotechnical Engineering (MindTap Course List)

What does the term 3 Vs refer to?

Database Systems: Design, Implementation, & Management

Name and briefly describe the purpose of the four financial statements.

Cornerstones of Financial Accounting

Identify and briefly describe the five key organizational complements that must be in place to ensure successfu...

Fundamentals of Information Systems

Determine the maximum tensile, compressive, and shear stresses acting on the cross section of the tube at point...

Mechanics of Materials (MindTap Course List)

Explain the conceptual approach that should guide the creation of firewall rule sets.

Principles of Information Security (MindTap Course List)

Continuous enhancement of an existing product is an example of ___________ innovation.

Principles of Information Systems (MindTap Course List)

Using Figure P2.4 as your guide, work Problems 45. The DealCo relational diagram shows the initial entities and...

Database Systems: Design, Implementation, & Management

What steps can companies take to make sure that the users of a DSS system are able to use it effectively?

Fundamentals of Information Systems

Technician A replaces a damaged steel fuel line with one made of synthetic rubber. Technician B replaces a dama...

Automotive Technology: A Systems Approach (MindTap Course List)

What is the benefit of using the offset tailstock method for turning tapers?

Precision Machining Technology (MindTap Course List)

Repeat Problem 2.11 with the following data. 2.11 The grain-size characteristics of a soil are given in the fol...

Principles of Geotechnical Engineering (MindTap Course List)

Find the expansion work resulting when the volume of a gas increases from 1 ft3 to 5 ft3 against a constant pre...

Fundamentals of Chemical Engineering Thermodynamics (MindTap Course List)

What five questions typically are used in fact-finding? What other question does the Zachman Framework include?...

Systems Analysis and Design (Shelly Cashman Series) (MindTap Course List)

using Figure 5-27, what is the advantage of the suspended type magnet over the other two types of magnets?

Solid Waste Engineering

Draw a schematic diagram of a two-speed control circuit using a standard-duty selector switch for the high and ...

Electric Motor Control

What is a data classification model? How is data classification different from a clearance level?

Management Of Information Security

The total estimated volt-amperes for Circuit B10 has been calculated to be 1144 volt-amperes. How many amperes ...

EBK ELECTRICAL WIRING RESIDENTIAL

The bar ABC is constrained by the pin support A and the cable BD. Determine the force in the cable and the magn...

International Edition---engineering Mechanics: Statics, 4th Edition

Same as Problem 5.11-8, but let all the loads on the girder act as a uniform load (be sure to include the weigh...

Steel Design (Activate Learning with these NEW titles from Engineering!)

Determine the vertical deflection at joint G of the truss shown in Fig. P7.17 due to a temperature increase of ...

Structural Analysis

A defective LAT sensor or circuit may cause the fol lowing problems, except. hard engine starting rich or lean ...

Automotive Technology

You suspect that a machine on your network with the host name PRTSRV is issuing excessive broadcast traffic. Wh...

Network+ Guide to Networks (MindTap Course List)

Two-Step Verification Problem A website you are attempting to access requires two-step verification. In additio...

Enhanced Discovering Computers 2017 (Shelly Cashman Series) (MindTap Course List)

How far away should highly combustible materials be from any welding or cutting?

Welding: Principles and Applications (MindTap Course List)

If your motherboard supports ECC DDR3 memory, can you substitute non-ECC DDR3 memory?

A+ Guide to Hardware (Standalone Book) (MindTap Course List)