Question: I NEED HELP WITH QUESTION ASAP!! PLEASE GIVE ME THE CORRECT ANSWER!! THANKS!! 6. The following loan data is entered into an Excel worksheet: Loan

I NEED HELP WITH QUESTION ASAP!!

PLEASE GIVE ME THE CORRECT ANSWER!!

THANKS!!

6. The following loan data is entered into an Excel worksheet: Loan Principal, cell B8, $200,000 APR, cell B9, 8% Terms, cell B10, 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 fy is 0 ) A. =PMT(B9/12,B1012,BB,0,0) B. =PMT(B9,B10,B8,0,1) C. =PMT(B8,B9,B7,0,1) D. =PMT(B9/12,B1012,B8,0,1) E. =PMT(B9,B10,BB,0,0) F. None of the answers are correct. G. =PMT(B8,B9,B7,0,0)

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Accounting Questions!

I NEED HELP WITH QUESTION ASAP!! PLEASE GIVE ME THE CORRECT ANSWER!! THANKS!! 25. The following formula was entered into cell J10 on an Excel worksheet: =$D3/G8 If cell J10 is copied and pasted into...

I NEED HELP WITH QUESTION ASAP!! PLEASE GIVE ME THE CORRECT ANSWER!! THANKS!! 24. The following logical test was entered into cell H16 on an Excel worksheet: =C11>52 The output in cell H16 will be...

Hello, Need help with the following:Please see Rubric thks Using information from"Are You Paying Too Much for That Acquisition?" List and describe the components used to calculate synergy value....

PLEASE ANSWER IMMEDIATELY! PLEASE SHOW FORMULA FOR EXCEL FOR GRAY BOXES! READ THE FOLLOWING AND FILL IN THE EXCEL WORKSHEET! The house at 314 Baker Street, in Los Angeles County, sells on January 28...

Mount Moreland Hospital PERFORM FINANCIAL CALCULATIONS .GETTING STARTED Open the file NP_EX19_9a_FirstLastName_1.xlsx available for download from the SAM website. Save the file as...

Use EXCEL only please, also make a data analyst excel file thanks! EntertainmentTech Research Analyst - 50% You have been hired to work as a research analyst at Entertainment Tech. EntertainmentTech...

please comment so I can share you the link to excel file EX16_XL_COMP_GRADER_CAP_AS - Manufacturing 1.4 1.4 Project Description: You have recently become the CFO for Beta Manufacturing, a small cap...

Hi. I need Chapter 11 part 1-4 Let me know. Thanks! (it wont letme add more than $8, but I will give $12+ tip) Personal Finance, Fifth Edition by Jeff Madura BUILDING YOUR OWN FINANCIAL PLAN WORKBOOK...

I want to know how all the numbers are going and which ones are specific to organize them by cell 00 Estilos de celda v Formato y filtrar seleccionar datos G14 X V fx A B C D E F G H K L M N O Smith...

EX16_XL_COMP_GRADER_CAP_AS - Manufacturing 1.4 1.4 Project Description: You have recently become the CFO for Beta Manufacturing, a small cap company that produces auto parts. As you step into your...

II. Please try to analyze the following cases and write down the appropriate recoding process.. Payne Company purchased equipment in 2010 for $90,000 and estimated a $6,000 residual value at the end...

Why is worker involvement important to an organizations success?

Explain the dual transfer pricing approach in intracompany transfer pricing. 10 Discuss the statement, "Price setting is truly an art." II What methods are available that might assist and perniit the...

Hypothesis Testing of a Single Mean LCTCS Tuition: Louisiana Community And Technical College System consist of 2 community colleges across the state. I think RPCC's tuition and fees is lower than the...

Reword the following logical explanations for a negative message so that each has positive rather than negative words and tone. Consider what can be done rather than what cannot. Add necessary...

Global. Interview a person who is a native of another country to learn how negative messages would be conveyed in his or her homeland. (Objectives 3, 4, 5, and 6)

You own a 300-acre farm outside the city. Jack Ripsaw runs a local sawmill and has requested that you let him cut pulpwood from your farm and split the profit 50-50. Mr. Ripsaws reputation for...