Jane Wright Company is preparing an Excel spreadsheet for a 6-year finance lease. The implicit interest rate in the lease is 4%. The beginning of the lease is December 31, 2018. Lease payments are made each December 31 starting at December 31, 2018. A portion of the spreadsheet appears as follows: 
Required:
1. Using the format followed in cell D7, provide the appropriate formula for cell B6.
2. Using the format followed in cell D7, provide the appropriate formula for cell C8.
3. Using the format followed in cell D7, provide the appropriate formula for cell E8.
Definitions:
Demand Curves
A graphical representation showing the relationship between the price of a good or service and the quantity demanded for a given period.
Supply Curves
Graphical representations showing the relationship between the price of a good and the quantity of the good that suppliers are willing to offer for sale.
Market Equilibrium
A condition in which the supply of a good matches demand, leaving neither surplus nor shortage in the market.
Environmental Indicators
Measurements, statistical data, and analysis used to represent the health of the environment, guide public policy, and inform the public.
Q3: Current liabilities are normally recorded at the
Q27: Determine the price of a $500,000 bond
Q68: Recognizing tax benefits in a loss year
Q74: When an equity method investment is sold,
Q81: What is the effective interest rate (rounded)
Q97: In which investment category are fair values
Q124: Deferred tax asset<br>A)Is usually a revenue or
Q142: On September 1, 2018, Red Co., issued
Q146: <br>What should Kent report as the current
Q208: Delayed recognition in earnings<br>A)Future compensation levels estimated.<br>B)Not