Suppose That You Are Considering an Investment That Will Pay

question 65

Multiple Choice

Suppose that you are considering an investment that will pay you $4000 per year for the next five years.The appropriate rate of interest is 5%.You want to know the present value of the cash flows from this investment.To solve this problem in Microsoft Excel,you would use which of the following excel formulas?

• A)=PV(.05,5,4000,0,0)
• B)=PV(.05,5,4000,0,1)
• C)=PV(5,.05,4000,0)
• D)=PV(5,5,4000,0)

---

Definitions:

Variable Expense Ratio

A measurement that indicates the proportion of variable expenses to sales, showing how costs change with sales volume.

Break-even Point

The sales amount where the total income matches the total expenses, leading to neither profit nor loss for the company.

High-low Method

An analytical technique used in accounting and finance to estimate fixed and variable costs associated with business operations based on the highest and lowest levels of activity.

Fixed Cost

Costs that do not vary with the level of production or sales, remaining constant regardless of the amount of goods or services produced or sold.