The following loan data is entered into an Excel worksheet: Loan Principal, cell B5, $150,000 APR,...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
The following loan data is entered into an Excel worksheet: Loan Principal, cell B5, $150,000 APR, cell B6, 5% Terms, cell B7, 30 years Assume loan payments are made annually at the beginning of the year. Which of the following functions will accurately calculate the required annual payment for this loan? (assume the fv is 0) O None of the answers are correct. -PMT(B6,B7,-B5,0,0) O PMT(B6,B7, B5,0,1) -PMT(B6,B7,-85,1,0) -PMT(B6,B7,B5,0,0) The following loan data is entered into an Excel worksheet: Loan Principal, cell B5, $150,000 APR, cell B6, 5% Terms, cell B7, 30 years Assume loan payments are made annually at the beginning of the year. Which of the following functions will accurately calculate the required annual payment for this loan? (assume the fv is 0) O None of the answers are correct. -PMT(B6,B7,-B5,0,0) O PMT(B6,B7, B5,0,1) -PMT(B6,B7,-85,1,0) -PMT(B6,B7,B5,0,0)
Expert Answer:
Answer rating: 100% (QA)
Step 11 Below is the formula of function PMT PMTrate nper pv fv type Rate required The intere... View the full answer
Related Book For
Income Tax Fundamentals 2013
ISBN: 9781285586618
31st Edition
Authors: Gerald E. Whittenburg, Martha Altus Buller, Steven L Gill
Posted Date:
Students also viewed these accounting questions
-
At the beginning of the year (January 1), Buffalo Drilling has $ 11,000 of common stock outstanding and retained earnings of $ 8,200. During the year, Buffalo reports net income of $ 8,500 and pays...
-
At the beginning of the year you bought 250 shares of Lycel Ltd. at $82 each. During the year you received dividends of $750. At the end of the year the stock is trading for $87 and you decide to...
-
At the beginning of last year you invested $30,000 in 1,500 shares of Goran Products Inc. During the year you received $4,500 as a dividend. At the end of the year you sold the shares for $18 each....
-
Selected information from Indigo Books & Music Inc.'s income statements for three recent years follows (dollars in thousands): Instructions (a) Calculate gross profit, and profit from operations, for...
-
Companies generate income from their "regular" operations and from other sources like interest earned on the securities they hold, which is called non-operating income. Lindley Textiles recently...
-
A normal distribution has a mean equal to 10. What is the standard deviation of this normal distribution if the cutoff for the bottom 5% is x = 12.47?
-
A \(\$ 100,000\) bond priced at 103.5 can be bought or sold for a. \(\$ 100,000+\) interest b. \(\$ 103,500\) c. \(\$ 3,500\) d. \(\$ 10,350\)
-
The following data come from the financial statements of Mitchell Company for the year ended March 31, 2015 (in millions): Requirements 1. Prepare a cash flow statement for the year ended March 31,...
-
3) Jamie makes a triangular pen to keep the puppies he just adopted. The lengths of the sides of the pen are 38 inches, 31 inches, and 35 inches. Determine the area of the pen. Round to the nearest...
-
Determine the moments of inertia I x and I y of the area shown with respect to centroidal axes respectively parallel and perpendicular to side AB. 60 mm 320 mm 40 mm so mm 80 inm 330 mm 80 mm
-
Computer-Administered: This is a survey that is conducted using computer technology. The researcher uses technology to record data results. Self-Administered: This is a survey where the researcher is...
-
knowledge management systems have become a tool or facility to support the learning process." Analyse the SECI model and determine how the dimensions of the SECI model is applied for knowledge...
-
Part 1: Explain what fact analysis is and why it is important to an investigator Part 2 : Explain why an investigator should not rely on a physician's estimate of the time of death of a victim or the...
-
0.20 m 0.10 m -100 V +100 V Two thin, concentric, conducting spherical shells, insulated from each other, have radii of 0.10 m and 0.20 m, as shown above. The inner shell is set at an electric...
-
Thermal Rising, Incorporated, makes paragliders for sale through specialty sporting goods stores. The company has a standard paraglider model, but also makes custom-designed paragliders. Management...
-
It is the first week of December and Christmas break is right around the corner when a close colleague of yours approaches you in confidence. Kelley Garcia is also a second year teacher and you were...
-
Design and construct a circuit with exactly one battery ( 1 . 5 V ) and all four light bulbs ( 1 . 0 Q ) such that the current measured by the ammeter is as large as possible. What is the largest...
-
Medi-Exam Health Services, Inc. (MEHS), located in a major metropolitan area, provides annual physical screening examinations, including a routine physical, EKG, and blood and urine tests. MEUS's...
-
Tom has a successful business with $100,000 of income in 2012. He purchases one new asset in 2012, a new machine which is 7-year MACRS property and costs $25,000. If you are Tom's tax advisor, how...
-
Joan is a self-employed attorney in New York City. Joan took a trip to San Diego, CA, primarily for business, to consult with a client and take a short vacation. On the trip, Joan incurred the...
-
Carl Conch and Mary Duval are married and file a joint return. They live at 1234 Mallory Sq. Apt. 64, Key West, FL 33040. Carl works for the Key Lime Pie Company and Mary is a homemaker after losing...
-
What is the purpose of tests of controls?
-
Why are some tests of controls performed during the interim period?
-
What four factors should the auditor consider in deciding what evidence, if any, needs to be obtained during the period from the interim date to the balance sheet date?
Study smarter with the SolutionInn App