M & O Company Is Preparing an Excel Spreadsheet for a 5-Year

question 21

Multiple Choice

M & O Company is preparing an Excel spreadsheet for a 5-year finance lease. The implicit interest rate in the lease is 6%. The beginning of the lease is January 1. Lease payments are made each December 31. A portion of the spreadsheet appears as follows:
- What formula should M & O use in cell E8 to calculate the carrying value of the lease payable after the second lease payment?

• A) =E7-D8
• B) =E7+D8
• C) =E8+D8
• D) =PV(C2,C3,0,C1,type)

Calculate opportunity costs and identify comparative advantages from given data.

Understand the conditions under which countries can benefit from trade.

Interpret economic data tables to assess the outcomes of different trade scenarios.

Explain the economic rationale behind exporting and importing goods.

---

Definitions:

Rival in Consumption

A characteristic of a good where its consumption by one person reduces its availability for another person.

Substitutes

Goods or services that can replace each other in use or consumption, where an increase in the price of one leads to an increase in demand for the other.

Nonrival in Consumption

Nonrival in Consumption describes a good where one individual's consumption does not reduce availability to others, such as a public broadcast.

Efficient Price

Price level at which the quantity demanded and supplied in a market are at equilibrium, leading to an optimal distribution of resources.