FREE Trial
Answered step by step
Verified Expert Solution
Link Copied!
Question
1 Approved Answer

Excel Finance Help John just took out a $24,000 bank loan to help purchase his dream car. The bank offered a 5-yearloan at a 6%

Excel Finance Help

John just took out a $24,000 bank loan to help purchase his dream car. The bank offered a 5-yearloan at a 6% APR. The loan will feature monthly payments and monthly compounding of interest. What is the monthly payment for this car loan?

image text in transcribed

I need answer for B52, B53,B54

B52) Monthly Payment (Excel Function)

B53) VBA Formula ( please provide the VBA Code)

B54) Math Formula

All 3 answers should be the same

B A 48 Q7) John's Car Payment 49 PV 50 Years (N) 51 Rate (R) 52 Monthly Payment (Excel Function) 53 Your VBA formula 54 Math Formula 55 $24,000.00 5.0 6.00%

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image
Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Global Banking
Global Banking

Authors: Roy C Smith, Ingo Walter, Gayle DeLong

3rd Edition

0195335937, 9780195335934

More Books

Students explore these related Finance questions

Question

Would the outcome in this case have been affected if the title certificates had been filed in a database that could be accessed online? Explain.

Answered: 3 weeks ago

Question

(b) Determine the best course of action for AFe.

Answered: 3 weeks ago

Question

3. Use the childs name.

Answered: 3 weeks ago

Question

Charles Austin of the controller's office of Thompson Corporation was given the assignment of determining the basic and diluted earnings per share values for the year ending December 31, 2018. Austin...

Answered: 3 weeks ago

Question

Patricia was supposed to pay Brittany $4,900, 6 months ago, and $2,200, 5 months from now. If she wants to reschedule these payments with two payments, one payment of $3,200 today and the balance 3...

Answered: 3 weeks ago

Question

Alice J. and Bruce M. Byrd are married taxpayers who file a joint return. Their Social Security numbers are 123-45-6784 and 111-11-1113, respectively. Alice's birthday is September 21, 1972, and...

Answered: 3 weeks ago

Question

Smith Enterprises recently was profiled on a financial information website and touted as a "hot" growth stock. You acquired the stock quote shown here from that website. Smith Enterprises (DAX: SME)...

Answered: 3 weeks ago

Question

A knife found buried 7 inches deep in the ground would be marked on the evidence collection site map as _____. a. -7 b. 7 c. 7 BG d. UG 7

Answered: 3 weeks ago

Question

Week 14 Homework i 5 points 1 Saved Andretti Company has a single product called a Dak. The company normally produces and sells 83,000 Daks each year at a selling price of $60 per unit. The company's...

Answered: 3 weeks ago

Question

3. The normal melting point of CaTiSiO5 is 1,400C and the heat of fusion at the normal melting point is 123,700 J mol-. Calculate the heat of fusion at 1,300C. Cp, solid CaTiSiO5 = 177.4 +23.2 10- TJ...

Answered: 3 weeks ago

Question

LAND DESCRIBED AS FOLLOWS Schains 21LINKS Achains 21 Links N 40 30' E 4 chains 25 LINKS 3 chains H 49 30' W. OLD 5 chains N 40 30' E FARM ROAD 1. Determine the area of the enclosed property in square...

Answered: 3 weeks ago

Question

2. There is no simple solution to the distractions that we face in our personal and work lives. Jackson states that the solution to the issue is self-discipline. Many distractions are self-initiated....

Answered: 3 weeks ago

Question

1. During the next week, study the listening habits of students in another class in which you are enrolled. Keep a journal of your observations by identifying the nonverbal behaviors you witness. Are...

Answered: 3 weeks ago

Question

3. Many times, we take the conversation away from others and make it our own. This practice not only wastes time, but is a major relationship killer. Here is how it works: At the beginning of the...

Answered: 3 weeks ago

Previous Question Next Question