Question: please do it i excell and show formula Question 1 O out of 10 points What is the price of a car if the loan

please do it i excell and show formula

please do it i excell and show formula Question 1 O out

Question 1 O out of 10 points What is the price of a car if the loan from the bank to buy it involves annual payments of $6,110.00 to the bank for 6 years at an annual interest rate of 10.76 percent with the first X annual payment made to the bank in 1 year and a special payment of $5,690.00 to the bank in 2 years?(Round the value to 10th decimal and enter positive value) Selected Answer: [None Given] Correct Answer: 30,666.45 Answer range +/- 61.3329 (30605.1171 - 30727.7829) Question 2 O out of 10 points What is the price of a car if the loan from the bank to buy it involves annual payments of $7,440.00 to the bank for 6 years at an annual interest rate of 9.24 percent with the first X annual payment made to the bank in 1 year and a special payment of $4.940.00 to the bank in 6 years?(Round the decimal to 100th place) Selected Answer: [None Given] Correct Answer: 36,044.71 Answer range +/- 72.08942 (35972.62058 - 36116.79942)

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 Finance Questions!

Question 1: (Financial Statement Analysis) 10 points Consider the following sets of financial statements and answer the questions that follow: a. Which firm is the most liquid? Why? (Justify your...

Question 1: (Financial Statement Analysis) 10 points Consider the following sets of financial statements and answer the questions that follow: *Look at the uploaded document to see the chart for...

please read the 4 page artical and answer the 5 questions. the 5 question relate to eachother. each question should be 150 - 250 words. please number the answers. thank you so much. Question 1: What...

please show work Question 7 O out of 10 points John Q. Investor purchased a semi-annual coupon- bearing Treasury at par. The duration was 17 years. Yield then rose 1% to 14.84%. Therefore, the price...

I'm not sure how this needs more info in case an "expert" says it does this is all the info I am given to complete the assignment. Independent Project 1 - Budget Excel project. Could someone help me...

SHOW PICTURE FOR THIS ASSIGNMENT Project Overview You are interested in obtaining a loan to buy a new automobile, and you must convince a banker that you have the money required to afford the car...

I need short journal entries for these articles, please. 1) Learning Objectives By the end of this section, you will be able to: Explain the various functions of money Contrast commodity money and...

can you please show step by step how to show question 1 and 2 In 2012, Marty was very unhappy with her bank - the United Bank of San Jose - and in Jamuary switched her banking relationship to the San...

Ahmad is a single man and a software engineer living in Gombak. His workplace is located in Bandar Utama. His net income is RM 3,000. The distance between his place and his workplace is 20.5 km....

Background Information Your boss, a real estate business manager, has approached you for financial advice. She is interested in either purchasing or leasing a new car for her personal use. Aware of...

Which of the following is true? Tax-exempt interest income will decrease shareholder basis. Like a general partner, a shareholder is responsible for the recourse debts of the S corporation. When a...

A market researcher selects a simple random sample of n = 100 Twitter users from a population of over 100 million Twitter registered users. After analyzing the sample, she states that she has 95%...

You are auditing Raji and Company. You discover an item of inventory with an audited value of $ 5 , 0 0 0 with a recorded amount of $ 3 , 0 0 0 . If this is the only error you discover, the projected...

Questions Q1. Write a Python program to retrieve the first and last colors from the following list: color_list = ["red", "green", "white", "blue", "black") Q2. Given the following dictionary,...

Motivates others to deliver the highest standards by giving constructive feedback, praise and recognition.

Is self-disciplined, clearly focussed on achieving the best results for the company.

Takes time out to coach team members to develop their skills and maximize their contribution. Professional integrity