Question: Please show excel formula: Your uncle will sell you his bicycle shop for $500,000, with seller financing, at a 6.00% nominal annual rate. The terms

Please show excel formula:

Your uncle will sell you his bicycle shop for $500,000, with "seller financing," at a 6.00% nominal annual rate.

The terms of the loan would require you to make 12 equal end-of-month payments per year for four (4) years, and then make an additional final (balloon) payment of $75,000 at the end of the last month.

a. What would your equal monthly payments be?

b. How much of your second monthly payment is interest?

c. How much of your second monthly payment is repayment of principal?

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!

last column is other Swifty Supply Company, a newly formed corporation, incurred the following expenditures related to Land, to Buildings, and to Machinery and Equipment.Determine the amounts that...

Your uncle will sell you his bicycle shop for $500,000, with "seller financing," at a 6.00% nominal annual rate. The terms of the loan would require you to make 12 equal end-of-month payments per...

Please see the attachment and answer all questions 1. Compute the cost of not taking the following cash discounts. (Use a 360-day year. Do not round intermediate calculations. Input your final...

Suppose you deposited S5.000 in a hank account that pays 5.25% with daily compounding based on a 360-day year How much would be in the account after 8 months, assuming each month has 30 days? Suppose...

Check My Work Your uncle will sell you his bicycle shop for $ 2 8 0 , 0 0 0 , with "seller financing," at a 6 . 0 % nominal annual rate. The terms of the loan would require you to make 1 2 equal end...

PLEASE SHOW WORK IN EXCEL Your uncle will sell you his bicycle shop for $500,000, with "seller financing," at a 6.00% nominal annual rate. The terms of the loan would require you to make 12 equal...

Please show how do do in excel and show how you got the numbers with formulas and the seperate parts for each of the 4 questions thanks 1. Your firm borrows $150,000 to expand the current offices....

33. Suppose the U.S. Treasury offers to sell you a bond for $747.25. No payments will be made until the bond matures 5 years from now, at which time it will be redeemed for $1,000. What interest rate...

could you please include the N, I,PV, PMT, FV in your solution. thanks You plan to borrow $48,000 at a 7.5% annual interest rate. The terms require you to amortize the loan with 7 equal end-of-year...

81. Your uncle will sell you his bicycle shop for $110,000, with "seller financing," at a 6.0% nominal annual rate. The terms of the loan would require you to make 12 equal end-of-month payments per...

Explain why most peoples marginal tax rate is higher than their average tax rate. Is a system in which average tax rates are higher than marginal tax rates regressive, proportional, or progressive?

Use the data from Exercise 1 and the equation = 818.13 + 0.434571x to calculate a. The residuals b. The sum of the residuals c. The squares of the residuals d. The sum of the squares of the residuals...

To fulfill the segregation of duties control objective, computer processing functions ( like authorization of credit and billing ) are separated. a . True b . False

McKnight Exercise Equipment, Inc. reported the following financial statements for 2015: Requirements 1. Compute the amount of McKnight Exercises acquisition of plant assets. McKnight Exercise...

Rouse Exercise Equipment, Inc. reported the following financial statements for 2018: Requirements 1. Compute the amount of Rouse Exercise's acquisition of plant assets. Assume the acquisition was for...

Barry Corporation sold a machine used in its business for two years for $27,000. The machine originally cost $24,000 and it had an adjusted basis at the time of the sale of $17,000. Determine the...

SodaKing manufactures and sells three soft drinks: Kola, Limor, and Orlem. Budgeted and actual results for 2015 are as follows: Required 1. Compute the total sales-volume variance, the total...

Cincinnati Paint Company sells quality brands of paints through hardware stores throughout the United States. The company maintains a large sales force whose job it is to call on existing customers...

Design a minimum-mass symmetric three-bar truss (the area of member 1 and that of member 3 are the same) to support a load P, as was shown in Fig. 2.9. The following notation may be used: Pu = P cos...

Explain the difference between executive pay with pay for nonexecutives.

Explain disability benefits under OASDI. Compare it with workers compensation.

Summarize the executive compensation disclosure rules and the reasons why they have been established.