Chapter 11 - Exercise 03 Kyle Godwin is interested in buying a 24-foot pontoon boat for...

Chapter 11 - Exercise 03

Kyle Godwin is interested in buying a 24-foot pontoon boat for $11,850. His credit union’s terms are 10% down, 14% interest, and 24 months to pay off the loan. Calculate the amount to be financed, the interest, the amount to be repaid, and the monthly payment.
Terms of Loan		Payment Calculations
Purchase Price	$11,850.00	Amount to be Financed
Down Payment Percent	10%	Interest
Interest Rate	14%	Amount to be Repaid
Term (months)	24	Monthly Payment

Directions:
a. Enter a formula in Cell D5 to calculate the Amount to be Financed.
b. Enter a formula in Cell D6 to calculate the Interest.
c. Enter a formula in Cell D7 to calculate the Amount to be Repaid.
d. Enter a formula in Cell D8 to calculate the Monthly Payment.
e. Format Column D for Currency. Set Decimal places to 2. Set Currency symbol to $.
f. Save the file as *ch11ex03a.xlsx.*

Expert Solution

Answer- A:

Amount need to be Financed = Purchase Price - Down Payment = $11,850 - 10% of $11850 = $10,665.00

Answer- D

To calculate Monthly Payment use the "PMT" function of excel as follow:

$512.06

Answer- B

To calculate interest to be paid use the CUMIPMT function of excel;

$1,624.38

Answer- C;

Amount to be repaid = Monthly Installment * No. of Payments = $512.06 * 24 = $12,289.44

jeff jeffy answered 1 year ago

Write program for the exercise 11(Sales Analysis) as explained at the end of the chapter. 11....

Write program for the exercise 11(Sales Analysis) as explained at the end of the chapter. 11. sales Analysis The file SalesData.txt, in this chapter’s source code folder, contains the dollar amount of sales that a retail store made each day for a number of weeks. Each line in the file contains seven numbers, which are the sales numbers for one week. The numbers are separated by a comma. The following line is an example from the file: 2541.36,2965.88,1965.32,1845.23,7021.11,9652.74,1469.36 Write a...

Justin is interested in buying a digital phone. He visited 11 stores at random and recorded...

Justin is interested in buying a digital phone. He visited 11 stores at random and recorded the price of the particular phone he wants. The sample of prices had a mean of 188.08 and a standard deviation of 10.94. (a) What t-score should be used for a 95% confidence interval for the mean, μ, of the distribution? t* = equation editorEquation Editor (b) Calculate a 95% confidence interval for the mean price of this model of digital phone: (Enter the...

Exercise 24-11 Drake Corporation is reviewing an investment proposal. The initial cost and estimates of the...

Exercise 24-11 Drake Corporation is reviewing an investment proposal. The initial cost and estimates of the book value of the investment at the end of each year, the net cash flows for each year, and the net income for each year are presented in the schedule below. All cash flows are assumed to take place at the end of the year. The salvage value of the investment at the end of each year is equal to its book value. There...

Chapter 11 Exercise A4 Assume a company is going to make an investment of $450,000 in...

Chapter 11 Exercise A4 Assume a company is going to make an investment of $450,000 in a machine and the following are the cash flows that two different products would bring in years one through four. Option A, Product A Option B, Product B $190,000 $150,000 190,000 180,000 60,000 60,000 20,000 70,000 Which of the two options would you choose based on this payback method?

Modified from Chapter 07 Programming Exercise 5 Original Exercise: Rock, Paper, Scissors Modification Programming Exercise 11...

Modified from Chapter 07 Programming Exercise 5 Original Exercise: Rock, Paper, Scissors Modification Programming Exercise 11 in Chapter 6 asked you to design a program that plays the Rock, Paper, Scissors game. In the program, the user enters one of the three strings—"rock", "paper", or "scissors"—at the keyboard. Add input validation (with a case-insensitive comparison) to make sure the user enters one of those strings only. Modifications: Allow the user to input "r", "p", "s" or the full strings "Rock",...

Programming Exercise 11-2 QUESTION: In this chapter, the class dateType was designed to implement the date...

Programming Exercise 11-2 QUESTION: In this chapter, the class dateType was designed to implement the date in a program, but the member function setDate and the constructor do not check whether the date is valid before storing the date in the member variables. Rewrite the definitions of the function setDate and the constructor so that the values for the month, day, and year are checked before storing the date into the member variables. Add a member function, isLeapYear, to check...

C++ PROGRAM Programming Exercise 11 in Chapter 8explains how to add large integers using arrays. However,...

C++ PROGRAM Programming Exercise 11 in Chapter 8explains how to add large integers using arrays. However, in that exercise, the program could add only integers of, at most, 20 digits. This chapter explains how to work with dynamic integers. Design a class named largeIntegers such that an object of this class can store an integer of any number of digits. Add operations to add, subtract, multiply, and compare integers stored in two objects. Also add constructors to properly initialize objects...

please show me step by step? Chapter 11 Exercise 11-8 Volume Trade-Off Decisions [LO11-5, LO11-6] Barlow...

please show me step by step? Chapter 11 Exercise 11-8 Volume Trade-Off Decisions [LO11-5, LO11-6] Barlow Company manufactures three products—A, B, and C. The selling price, variable costs, and contribution margin for one unit of each product follow: Product A B C Selling price $ 180 $ 270 $ 240 Variable expenses: Direct materials 24 80 32 Other variable expenses 102 90 148 Total variable expenses 126 170 180 Contribution margin $ 54 $ 100 $ 60 Contribution margin ratio...

Exercise 14-24 Convertible bonds [LO14-5] On January 1, 2018, Gless Textiles issued $11 million of 8%,...

Exercise 14-24 Convertible bonds [LO14-5] On January 1, 2018, Gless Textiles issued $11 million of 8%, 20-year convertible bonds at 101. The bonds pay interest on June 30 and December 31. Each $1,000 bond is convertible into 40 shares of Gless’s no par common stock. Bonds that are similar in all respects, except that they are nonconvertible, currently are selling at 99 (that is, 99% of face amount). Century Services purchased 20% of the issue as an investment. Required: 1....

Challenge Exercise 3- Chapter 7 Expands on: E7-11 LO: 3 The following information pertains to Two Guys...

Challenge Exercise 3- Chapter 7 Expands on: E7-11 LO: 3 The following information pertains to Two Guys Video Company. 1. Cash balance per bank, July 31, $7,363. 2. July bank service charge not recorded by the depositor $22. 3. The bank erroneously charged another company’s $700 check against Two Guys’ account. 4. Cash balance per books, July 31, $8,784. 5. The bank charged Two Guys account $350 for a customer’s NSF check. 6. Deposits in transit, July 31, $2,200. 7. Two...

Question