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 2 years 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...

Chapter 24-Problems PR.24-02.ALGO PR.24-03.ALGO Hide or show questions Progress:1/2 items eBook Show Me How Calculator Profit...

Chapter 24-Problems PR.24-02.ALGO PR.24-03.ALGO Hide or show questions Progress:1/2 items eBook Show Me How Calculator Profit Center Responsibility Reporting for a Service Company Thomas Railroad Company organizes its three divisions, the North (N), South (S), and West (W) regions, as profit centers. The chief executive officer (CEO) evaluates divisional performance using income from operations as a percent of revenues. The following quarterly income and expense accounts were provided from the trial balance as of December 31: Revenues—N Region $868,700 Revenues—S...

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...

Chapter 11 Exercise A6 The management of Kawneer North America is considering investing in a new...

Chapter 11 Exercise A6 The management of Kawneer North America is considering investing in a new facility and the following cash flows are expected to result from the investment: Year Cash Outflow Cash Inflow 1 $1,900,000 $100,000 2 550,000 200,000 3 360,000 4 480,000 5 510,000 6 600,000 7 590,000 8 300,000 9 250,000 10 250,000 A. What is the payback period of this uneven cash flow? B. Does your answer change if year 10's cash inflow changes to $500,000?

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...

Question