A manufacturer needs to borrow money to purchase a building. The purchase price of the building is $1.5 million, and the company will put $300,000 in cash down at closing. If the company can borrow the difference from its bank at 4.85% for 20 years, what will the monthly principal and interest payment of the loan be? Create an amortization schedule also
Q: e net price. Your buyer also need to pay the monthly amortization of 34,950 for 5 years.How much was…
A: Amortization is the allocation of the cost of an intangible asset over its life. The maximum life of…
Q: Your firm has taken out a $480,000 loan with 8.1% APR (compounded monthly) for some commercial…
A: The loans are paid the monthly payments that carry the payment for interest and the payment for the…
Q: Robinson Co. is interested in purchasing a new delivery vehicle so it can become a subcontractor…
A: Net Present Value: It is applied to series of cash flows happening at various times and represent…
Q: Sosa Excavating Inc. is purchasing a bulldozer. The equipment has a price of $100,000. The…
A: Step1: Calculating the value of total interest that Sosa pay on this installment plan. We have,The…
Q: A bag manufacturer will rent a space in a mall for 24 months for an exhibit. The monthly rent is…
A: Using excel PV and PMT function to calculate the single lumpsum payment
Q: DO IT IN EXCEL, AND SHOW THE FORMULAS If the company purchases the machine, its cost of $276,000…
A: Credit purchase is a system through which the purchaser can buy the asset without paying the value…
Q: To finance the purchase of a new factory recently, you’ve arranged for a 40-year mortgage loan for…
A: Annual percentage rate (APR) refers to the annual cost of funds borrowed. The APR is usually…
Q: Define the symbols involved when a construction company wants to know how much money it can spend 3…
A: Interest charged on the principal amount and the interest accrued is known as Compound Interest. It…
Q: A company needs to buy a building in 4 years, and must fund the down payment from its profits. The…
A: For availing a loan for an asset, a person is required to pay some amount as down payment. Down…
Q: A store manager plans to exchange his old computer at the end of four years for a newer one worth…
A: The future value of the annuity is the total value of all the payments which is occurred regularly…
Q: You want to buy a house that costs $60,000. You took a $60,000 mortgage loan at an annual rate of…
A: Note: As per our guidelines, we can only answer one question at once. Since, you haven't…
Q: One year ago, JK Mfg. deposited $20,500 in an investment account for the purpose of buying new…
A:
Q: Grouper Excavating Inc. is purchasing a bulldozer. The equipment has a price of $90,500. The…
A: Total interest=Total Payment-Amount Borrowed Annual Payment=Amount borrowedPresent value annuity…
Q: A buyer is considering purchasing a 10-acre parcel in Peoria, Arizona for economic development. The…
A: The concept of the time value of money states that the current worth of money is more than its value…
Q: Galvanized Products is considering the purchase of a new computer system for their enterprise data…
A: In this question firm wants to buy a new computer system.It will require an initial investment of…
Q: Your company has determined it can and is willing to pay a monthly mortgage payment of $12,000 (per…
A: Maximum amount the company can pay is present value of monthly payments
Q: A business sets up a sinking fund so they will have a $49,000.00 to pay for a replacement piece of…
A: The PMT function or concept can be used to determine the periodic payments required to accumulate a…
Q: An engineer wants to purchase a house for $100,000 and has $20,000 cash to use as the down payment.…
A: Cost of house = $100,000 Down payment = $20,000 Interest rate = 9% Time period = 20 years Payment…
Q: Robinson Co. is interested in purchasing a new delivery vehicle so it can become a subcontractor…
A: Investment Appraisal: It is a process a business attempts to assess likely significant activities…
Q: A firm considering the installation of an automatic data processing unit to handle some of its…
A: given, purchase price = P20,000 lease: year 1 = P8000 decrease every year = P1000 n= 4 r=15%
Q: A manufacturer needs to borrow money to purchase a building. The purchase price of the building is…
A: given, purchase price = $1.5 million = 1500,000 downpayment = $300,000 rate =4.85% n =20 years
Q: The executive of a label is looking to purchase a new rental for $3.9 million. Financing is offered…
A: Borrowings are the liability that is used to finance the requirement of the funds. The borrower…
Q: The price of a new car is $32,000. Assume that an individual makes a down payment of 25% toward the…
A: Price of car = $ 32,000 down payment = 25% interest rate = 8% number of payments =24 Number of…
Q: You plan to make a lump-sum deposit of $5000 now into an investment account that pays 6% per year,…
A: Lump Sum Deposit = 5000 Return % = 6% Annual End of year withdrawals = 1000 Time Period of…
Q: What is the effective annual interest rate of this trade credit?
A: Credit term can be defined as the payment period for the credit sale or purchase of goods, which is…
Q: The D.J. Masson Corporation needs to raise 500,000 for 1 year to supply working capital to a new…
A: Due period=Total credit period-Discount period=90-10=80 days
Q: A mining firm makes annual deposits of $400,000 into a reclamation fund for 25 years. If the firm…
A: Interest: It can be defined as a payment or a charge that is made by the borrower to a lender.
Q: A business sets up a sinking fund so they will have a $46,000.00 to pay for a replacement piece of…
A: A Sinking fund refers to a fund that is kept aside or borrowed for the purpose of paying off a debt…
Q: Food Corporation of dalican wants money to construct a new granary. If the granary will cost…
A: In this we need to find out future value factor and from that we can get the quarterly deposit.
Q: Pinnacle Homes, a real estate development company, is planning to build five homes, each costing…
A: Formula: A = P x [ 1 + ( R / N ) ] NT Interest : Interest is a fee charged on the Borrowed…
Q: One university needs some maintenance. The owner of the university decides to deposit $400000 in an…
A: Present Value : Present worth is that amount which shown present Value of deposit done in future.
Q: Your company is considering purchasing an expensive plece of equipment. The manufacturer of the…
A: Present Value: The present value is the value of cash flow stream or the fixed lump sum amount at…
Q: A real estate development company is planning to build five homes, each costing $195,000, in 2…
A: We need to determine the cost of 5 homes then use the periodic interest rate, number of periods to…
Q: You want to by a boat and can afford payments of $350 per month for six years. The monthly interest…
A: Since you have asked multiple questions, we will solve the first question for you. If you want any…
Q: How much (in $) should the company invest now to have sufficient funds to build the homes in the…
A: Present Worth: It is the present value of the sum of the amount discounted at a specific rate of…
Q: How many years will it take Rexchem, Inc. to accumulate $400,000 for a chemical feeder if the…
A: The present value is the value of the sum received at time 0 or the current period. It is the value…
Q: A real estate development company is planning to build five homes, each costing $155,000, in 2…
A: N = Time Period = 5 semi annual periods Future Value Required = Cost of each home * Number of homes…
Q: Skyline Industries will need $2.2 million in 4.5 years from now to replace some equipment.…
A: The discounted value of future value used to assess money's purchasing power is called the present…
Q: A small business has determined that the machinery they currently use will wear out in 17 years. To…
A: The question is based on the concept of Financial Management.
Q: Rizzo Excavating Inc. is purchasing a bulldozer. The equipment has a price of $100,000. The…
A: a.
Q: You are the owner of a book store and you are considering adding a coffee bar to your store. The…
A: NPV is the net current worth of cash flows that are expected to occur in the future.
Q: A company has had record profits and decided to use some of the profits to pay for manufacturing…
A: Annuity is the series of payment made by an investor at fixed interval for specified period of time.…
Q: A chemical engineer wants to deposit an amount now such that she can withdraw an equal annual amount…
A: Cash flow diagram:
Q: A pulp and paper company is planning to set aside $150,000 now for possibly replacing its large…
A: Future value = Present value * (1+ rate)^no. of years 8)
Q: The D.J. Masson Corporation needs to raise $500,000 for 1 year to supplyworking capital to a new…
A: Credit term can be defined as the payment period for the credit sale or purchase of goods, which is…
Q: A new car will cost $24,000 to buy and $5500 annually to operate. If it is sold for $9300 after 6…
A: EUAC is the equivalent annual cost of operating machinery it includes initial cost and an annual…
A manufacturer needs to borrow money to purchase a building. The purchase price of the
building is $1.5 million, and the company will put $300,000 in cash down at closing. If the
company can borrow the difference from its bank at 4.85% for 20 years, what will the monthly
principal and interest payment of the loan be? Create an amortization schedule also.
Step by step
Solved in 3 steps
- You want to buy a car, and a local bank will lend you $40,000. The loan will be fully amortized over 10 years, and the nominal interest rate will be 8% with interest paid annually. 1: What will be the annual loan payment? 2: Construct Amortization Schedule Table.A property has a FMV of $7,500,000. If the property owner can only secure a loan with an LTV of 70%, a loan amortization of 30 years, and an interest rate of 8.125%, then a) What is the monthly payment for this loan? and b) What is the outstanding balance on the loan after eight years? (Make sure to show how you arrived at your answer by identifying inputs if you used your hand-held calculator).Suppose that you need an amount of money which equals to $10000000. It is possible to find it from bank A at an annual interest rate of 18% under 12 equal payment. If the first payment will be 1 month later the day you used the loan. Find the CF (Cash Flow), the equal payments and prepare the amortization table.
- Suppose you wish to purchase heavy equipment machinery and a commercial bank will lend you $65,000 for the transaction. The loan will be amortized over 5 years and the nominal interest rate will be 8% payable monthly. Calculate the monthly payment and the annual percentage rate (EAR) of the loan to be amortized.you wish to purchase real property. the lender will give you a 250000 fixed rate 30 year mortgage at 3.5% per annum. suppose that before you can make any payments you receive a pay raise so you can pay an extra 200 per month with your normal payment. how many payments are required to fully amortize the loan assuming the extra 200 is paid each month?You organize an investment team to purchase a commercial property for $850,000. The bank demands a 20% down payment with the rest to be mortgaged at an annual interest rate of 6.5%. What amount is to be mortgaged? What will be the monthly payment if the length of the mortgage is 15 years? What will be the total amount of interest payed?
- Ace Development Company is trying to structure a loan with the First National Bank. Ace would like to purchase a property for $2.5 million. The property is projected to produce a first year NOI of $200,000. The lender will allow only up to an 80 percent loan on the property and requires a DCR in the first year of at least 1.25. All loan payments are to be made monthly, but will increase by 10% at the beginning of each year for five years. The contract rate of interest on the loan is 12%. The lender is willing to allow the loan to negatively amortize; however, the loan will mature at the end of the five-year period. What will the balloon payment be at the end of the fifth year (rounded to the nearest dollar)? Question 11 options:You are purchasing a home for $ 395,000. The loan requires a down payment of 15% of the purchase price. There are no other fees. The rest will be borrowed through a 7.35% (CIA ) amortized loan with annual payments for 20 years. What will the annual payment be on the loan?We suggest the use of a spreadsheet to create the amortization tables. You take out a 30-year mortgage for $70,000 at 9.45%, to be paid off monthly. Construct an amortization table showing how much you will pay in interest each year for the first 15 years and how much goes toward paying off the principal. If you sell your house after 15 years, how much will you still owe on the mortgage according to the amortization table? HINT [See Example 8.] (Round your answer to the nearest cent.) $
- Using a spread sheet, calculate the annual payments on a loan for $ 100,000, 10-year loan, 5% per year interest. Then build an amortization schedule for this loan. Develop an amortization for a $100, 000 loan, 5% interest, the annual payments will begin at $4,000 and increase by $1,000 per year until the loan is paid. Then answer this question: How many years will it take to pay off this loan?Ace Development Company is trying to structure a loan with the First National Bank. Ace would like to purchase a property for $3.50 million. The property is projected to produce a first year NOI of $140,000. The lender will allow only up to an 80 percent loan on the property and requires a DCR in the first year of at least 1.25. All loan payments are to be made monthly but will increase by 3.5 percent at the beginning of each year for five years. The contract rate of interest on the loan is 5.5 percent. The lender is willing to allow the loan to negatively amortize; however, the loan will mature at the end of the five-year period. Required: a. What will the balloon payment be at the end of the fifth year? b. If the property value does not change, what will the loan-to-value ratio be at the end of the five-year period? Complete this question by entering your answers in the tabs below. Required A Required B What will the balloon payment be at the end of the fifth year? (Do not round…Ace Development Company is trying to structure a loan with the First National Bank. Ace would like to purchase a property for $3.25 million. The property is projected to produce a first year NOI of $125,000. The lender will allow only up to an 80 percent loan on the property and requires a DCR in the first year of at least 1.25. All loan payments are to be made monthly but will increase by 3.5 percent at the beginning of each year for five years. The contract rate of interest on the loan is 5.5 percent. The lender is willing to allow the loan to negatively amortize; however, the loan will mature at the end of the five-year period. Excel calculation would be appreciated! a. What will the balloon payment be at the end of the fifth year? b. If the property value does not change, what will the loan-to-value ratio be at the end of the five-year period?