Business, 17.06.2020 01:57 glizbethh00

A few years back, Dave and Jana bought a new home. They borrowed $230,415 at a fixed rate of 5.49% (15-year term) with monthly payments of $1,881.46. They just made their twenty-fifth payment and the current balance on the loan is $208,555.87.Interest rates are at an all-time low and Dave and Jana are thinking of refinancing to a new 15-year fixed loan. Their bank has made the following offer: 15-year term, 3.0%, plus out-of-pocket costs of $2,937. The out-of-pocket costs must be paid in full at the time of refinancing. Build a spreadsheet model to evaluate this offer. The Excel function:=PMT(rate, nper, pv, fv, type)Calculates the payment for a loan based on constant payments and a constant interest rate. The arguments of this function are as follows:rate = the interest rate for the loannper = the total number of paymentspv= present value - - the amount borrowedfv = future value - - the desired cash balance after the last payment (usually 0)type = payment type (0 = end of period, 1 = beginning of the period)For example, for Dave and Jana's original loan there will be 180 payments (12*15 = 180), so we would use =PMT( .0549/12, 180, 230415,0,0) = $1881.46. Note that since payments are made monthly, the annual interest rate must be expressed as a monthly rate. Also, for payment calculations, we assume that the payment is made at the end of the month. Assume that Dave and Jana have accepted the refinance offer, and that there is no pre-payment penalty, so that anything above the beyond the required payment is applied to the principal. Construct a spreadsheet model in Excel so that you may use Goal Seek to determine the monthly payment that will allow Dave and Jana to pay off the loan in 12 years. Do the same for 10 and 11 years. Which option for prepayment if any, would you choose and why?(Hint: Break each monthly payment up into interest and principal [the amount that gets deducted from the balance owed] Recall that the monthly interest that is charged is just the monthly loan rate multiplied by the remaining loan balance.)If required, round your answers to two decimal places. Pay off loan in yearsAdditional Payment10 Years$11 Years$12 Years$Which option for prepayment if any, would you choose and why?

Answers: 3

Show answers

Another question on Business

Business, 21.06.2019 21:00

During the first month of operations, martinson services, inc., completed the following transactions: jan 2 martinson services received $65,000 cash and issued common stock to the stockholders. 3 purchased supplies, $1,000, and equipment, $12,000, on account. 4 performed services for a customer and received cash, $5,500. 7 paid cash to acquire land, $39,000. 11 performed services for a customer and billed the customer, $4,100. martinson expects to collect within one month 16 paid for the equipment purchased january 3 on account. 17 paid for newspaper advertising, $600. 18 received partial payment from customer on account, $2,000. 22 paid the water and electricity bills, $430. 29 received $2,600 cash for servicing the heating unit of a customer. 31 paid employee salary, $2,900. 31 declared and paid dividends of $1,800. requirements 1. record each transaction in the journal. key each transaction by date. explanations are not required. 2. post the transactions to the t-accounts, using transaction dates as posting references. label the ending balance of each account bal, as shown in the chapter. 3. prepare the trial balance of martinson services, inc., at january 31 of the current year. 4. mark martinson, the manager, asks you how much in total resources the business has to work with, how much it owes, and whether january was profitable (and by how much)?

Answers: 1

Answer

Business, 22.06.2019 06:00

Why might a business based on a fad be a good idea? question 2 options: fads bring in the most customers. some fads are longer lasting than expected. fads have made some business owners incredibly wealthy. fads can take a business in a new direction.

Answers: 2

Answer

Business, 22.06.2019 17:00

Cooper sues company a in state court in south carolina, where he lives, for negligence alleging personal injury and property damage of $100,000 after a truck driven by an employee of company a rear-ended his pickup truck. company a is incorporated in delaware, has its headquarters in new york, but does a substantial amount of business in south carolina. claiming diversity of citizenship, company a seeks removal to federal district court, but cooper opposes the motion. which of the following is true regarding whether the case may be properly removed to federal district court? the amount in controversy satisfies diversity requirements; and if company a's nerve center is in a state other than south carolina, then the case may be properly removed to federal court.the amount in controversy satisfies diversity requirements; and because company a is incorporated and has its headquarters in a state other than south carolina, the case may be properly removed to federal court.because the amount in controversy satisfies diversity requirements and company a is incorporated in a state other than south carolina, the case may be properly removed to federal court regardless of where company a's headquarters, nerve center, or principal place of business is located.because the amount in controversy satisfies diversity requirements and company a is headquartered in a state other than south carolina, the case may be properly removed to federal court regardless of where company a is incorporated and regardless of the location of its nerve center.because the amount in controversy fails to satisfy jurisdictional requirements, regardless of the location of company a, the case may not be removed to federal court.

Answers: 1

Answer

Business, 22.06.2019 20:00

Afirm is producing at minimum average total cost with its current plant. draw the firm's long-run average cost curve. label it. draw a point on the lrac curve at which the firm cannot lower its average total cost. draw the firm's short-run average total cost curve that is consistent with the point you have drawn. label it.g

Answers: 2

Answer

You know the right answer?

A few years back, Dave and Jana bought a new home. They borrowed $230,415 at a fixed rate of 5.49% (...

Questions