Question

In: Finance

XYZ Company borrows $450,000 to purchase a piece of capital equipment. The term of the loan...

  1. XYZ Company borrows $450,000 to purchase a piece of capital equipment. The term of the loan is 20 years at an APR of 6.5%. What is the monthly payment?  
    1. N =

I =

PV =

PMT =

FV =

P/Y =

  1. After five years, APR falls to 4.75%. How much is the balance due on the loan?

                        N =

                        I =

                        PV =

                        PMT =

                        FV =

                        P/Y =

  1.   How much of the loan principle has XYZ Company paid off during the first five years?

                       

  1.   After five years, XYZ realizes the machinery has a longer productive life than originally estimated; what would the loan payment be if it took out a new 20 year

loan?

                        N =

                        I =

                        PV =

                        PMT =

                        FV =

                        P/Y =

Solutions

Expert Solution

1.
N=20
I=6.5
FV=0
P/Y=12
PV=-450000
CPT PMT=3355.0791

2.
N=15
I=6.5
PMT=-3355.0791
FV=0
P/Y=12
CPT PV=385151.0438

3.
64848.9562

4.
N=20
I=4.75
FV=0
P/Y=12
PV=-385151.0438
CPT PMT=2488.9370


Related Solutions

Suppose your business borrows $100,000 to purchase a piece of equipment. You will be borrowing the...
Suppose your business borrows $100,000 to purchase a piece of equipment. You will be borrowing the money and repaying it over a three year period with a fixed monthly payment at an annual interest rate of 6%. Construct a loan amortization table for this loan.
A local machine shop is requesting a $50,000 5 year term loan to purchase a piece...
A local machine shop is requesting a $50,000 5 year term loan to purchase a piece of equipment for its operation. What financial information would you, as the credit analyst, require the commercial loan officer to obtain from the business in order for you to analyze the request?
A company is considering the purchase of a piece of equipment that would cost $380,000 and...
A company is considering the purchase of a piece of equipment that would cost $380,000 and would last for 8 years. At the end of 8 years, the equipment would have a salvage value of $97,500. The equipment would provide annual cost savings of $85,000. The company requires a minimum pretax return of 12% on all investment projects. (Ignore income taxes.) Required: Provide your Excel input and the final net present value amount you calculated. (If a variable is not...
On July 1, 2020, a company borrows $500,000 under a long-term loan. The $500,000 will be...
On July 1, 2020, a company borrows $500,000 under a long-term loan. The $500,000 will be paid back in five annual instalments of $100,000 each, starting on June 30, 2021. What will be the company's long-term loan balance, shown in the long-term liability section of its statement of financial position, at December 31, 2021? a)$400,000. b)$350,000. c)$300,000. d)Cannot tell, as the interest rate on the loan has not been provided
Ron's Loan: Ron borrows $3,000,000 to purchase a warehouse. The annual interest rate on the loan...
Ron's Loan: Ron borrows $3,000,000 to purchase a warehouse. The annual interest rate on the loan is 8.25 percent, and the term of the loan is 15 years. Suppose Ron refinances the loan at the end of month 48 at the then prevailing interest rate of 8%. Rather than reducing his monthly payment, however, Ron decides to continue making the same monthly payments. How many months must Ron continue to make the payments on this new loan? (Round your answer...
Ron's Loan: Ron borrows $3,000,000 to purchase a warehouse. The annual interest rate on the loan...
Ron's Loan: Ron borrows $3,000,000 to purchase a warehouse. The annual interest rate on the loan is 8.25 percent, and the term of the loan is 15 years. How much principal will Ron pay in month 37? Enter your answer rounded to the nearest penny with no punctuation, but do not use the rounded intermediate results in future calculations involving Ron's Loan (keep all available decimals).
Ron's Loan: Ron borrows $3,000,000 to purchase a warehouse. The annual interest rate on the loan...
Ron's Loan: Ron borrows $3,000,000 to purchase a warehouse. The annual interest rate on the loan is 8.25 percent, and the term of the loan is 15 years. The loan requires the borrower to pay two discount points at the time of origination. A) What is the monthly payment necessary to amortize this loan? B) What is the balance on the loan at the end of month 36? C) How much interest will Ron pay in month 37?    D) How...
A company wants to purchase a piece of equipment in three years that will cost $28,000...
A company wants to purchase a piece of equipment in three years that will cost $28,000 according to their best estimates. What amount do they need to invest now in a 6% interest bearing account to be able to make that purchase?
The company purchased a piece of equipment. Terms of the purchase were as follows: $10,000 in...
The company purchased a piece of equipment. Terms of the purchase were as follows: $10,000 in cash immediately, followed by note payments of $20,000 at the end of each year for the next eight years. The market rate of interest is 9%. Make the journal entry necessary to record the initial purchase. Round all answers to the nearest whole dollar. Make the journal entries necessary to record the first cash payment of $20,000 at the end of the first year....
6) Company is considering the purchase of a piece of equipment in '12. The projected cost...
6) Company is considering the purchase of a piece of equipment in '12. The projected cost of the equipment is 50,000 The equipment will be depreciated via the MACRS - 5 year life This equipment is expected to generate the following economics: Revenue for first year will be          45,700 Revenue will increase by 1.0% per year thereafter Expenses for first year will be          29,700 Expenses will decrease by 1.0% per year thereafter Company's Capital Structure is as follows:...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT