DO IT IN EXCEL, AND SHOW THE FORMULAS The company purchases a machine, its cost of $726,000 will be financed with a loan at 13.8% interest for three years that requires equal semi-annual payments (annuities) that include principal and interest. What is the amount of the payment? A) $185,674.92 B) None of these amounts C) $311,662.13 D) $151,841.86
Q: BRCC is evaluating an option for funding its working capital during the next year. The company plans…
A: in this we have to calculate the interest and add to that to get required value.
Q: Firm ZLC will be receiving payments of $10,000 per month for consulting services, with first payment…
A: Future value of annuity The future value of annuity refers to the total value of the investment at…
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: An institutional lender is willing to make a loan for $1 million on an office building at a 10…
A: Excel Spreadsheet: Excel Workings:
Q: Analysts at Sky West Airlines did a 3 year projection of expenses. They calculated that the company…
A: Amount Required at the beginning of each 6 month period to buy fuel, oil, lube, and parts for…
Q: Sandhill, Inc., is purchasing machinery at a cost of $ 3,544,720. The company's management expects…
A: Payback period is The length of time required for an investment to generate cash flows sufficient…
Q: H&H Machine Systems Inc. needs to acquire a new lift truck for transporting final products to…
A: a. The calculation is: The formulae image is:
Q: To finance the development of a new product, a company borrowed $29,000 at 7% compounded monthly. If…
A: Compound Interest The type of interest that helps build wealth quickly is called compounding.…
Q: Cody Company wants to purchase an asset that costs $150,000. The full amount needed to finance the…
A: a. given, principal = $150,000 rate = 12% n = 6 calculate annual payment: annual loan payment =…
Q: An industrial firm can purchase a special machine for $70,000. A down payment of $5,000 is required,…
A: Cost of Machine = $70,000 Down payment = $5,000 number of installments =…
Q: Sexy Inc. makes use of the lockbox system, what would be the net benefit to the company? Use 365…
A: Given, Fixed Fee = P 50,000 Interest Rate = 6%
Q: The business plan for Knowlt, LLC, a start-up company that manufactures portable multigas detectors,…
A: Required: To compute the interest rate used to yield equivalent annual cash flows of $400,000 per…
Q: To finance the development of a new product, a company borrowed $36.000 at 9% compounded monthly. If…
A: The act of repaying a loan taken from a lender, combined with the relevant interest amount, is known…
Q: One year ago, JK Mfg. deposited $20,500 in an investment account for the purpose of buying new…
A:
Q: Pls help with below homework.
A: Effective annual interest rate(EAR) refers to the real rate of return that we earn on our savings or…
Q: The business plan for KnowIt, LLC, a start-up company that manufactures portable multigas detectors,…
A: IRR Annual growth rate of growth that is estimated to be generated from an investment.
Q: Your company borrows $500,000 from a bank to finance the purchase of a new machine. The nominal…
A: First let us calculate the 4 equal half yearly payments that need to be made. This can be calculated…
Q: Hydrex Mechanical Products plans to set aside $160,000 now for possibly replacing its large…
A: (a) (a) tabulated factors: F = P* (F / P, in, n) F = $160,000 * (F/P), 0.04,14) F = $160,000 *…
Q: a)A loan of $15,000 is made today at an interest rate of 18% compounded weekly, a payment of $3000…
A: Since you have asked multiple question, we will solve the first question for you. If you want any…
Q: A company is allocating $10 million to develop a new product. This money will be spent continuously…
A: Interest is an additional amount which is received on deposited amount. It increases the value of…
Q: U.S. Fax has been granted a loan from a commercial finance company for $1 million at a stated…
A: Effective Cost of Debt(ECD) refers to the total amount that is paid by borrower to lender for taking…
Q: A small analytical laboratory borrowed $26,000 (the original amount or the principal) at an interest…
A: Compound interest is referred as the interest which is calculated on principal amount which involves…
Q: Pearl Excavating Inc. is purchasing a bulldozer. The equipment has a price of $92,800. The…
A: Here, Equipment can be purchased by using bank loan or Manufacturer loan. Company will choose the…
Q: Every 15 days a company receives P10,000 worth of raw materials from its suppliers. The credit terms…
A: It is given that Price of Raw material – P 10,000 Frequency – every 15 days Discount – 2%, if paid…
Q: CEL, AND SHOW THE FORMULAS If the company purchases factory equipment, its $719,000 cost will be…
A: Company buy the equipment on loans by banks that are to be paid by equal annual payments to the…
Q: A company will need $40,000 in four years for a new addition. To meet the goal, the company will…
A: According to the concept of future value and present value, investor is estimating the nearest value…
Q: Analysts at Sky West Airlines did a 3 year projection of expenses. They calculated that the company…
A: Semi annual cost (C) = $ 15200 Interest rate = 4% Semi annual interest rate (r) = 4%/2 = 2% Period =…
Q: Just Water International Ltd. wants to purchase water purification equipment costing $117,000. The…
A: Excel Spreadsheet:
Q: What is the monthly payment? 2) How much of the first payment goes toward interest? 3) How much of…
A: As per company policy, it is only possible to solve the first 3 sub parts of this question.
Q: he company could save $6,000 per year in engineering costs by purchasing a new machine. The new…
A: Given, rate = 9% year = 12 periodic payment = $6000
Q: Manila Wines, Inc. is considering the purchase of a P1,500,000 machine that is expected to have…
A: The Payback Period is one of the traditional techniques of capital budgeting that does not take into…
Q: MacElroy Trucks recently purchased a new rig costing S130,000. They financed this purchase at 12…
A: Since you have asked multiple questions, we will solve the first question for you. If you want any…
Q: a) To upgrade its vehicles, the project Insignia is considering undertaking, the company is…
A: The loan is repaid by making monthly payment which means the interest on loan is compounding on…
Q: The company has sales of $ 10 million per year, all of which are from credit terms that require…
A: The average number of days that is taken by the company to recover its sales payment or its accounts…
Q: What is the final answers and the cash diagram of the following: 1. Mr. Reyes borrows P600,000 at…
A: NOTE: As per our policy, we only answer one question when different questions are posted.…
Q: Kenworth Imaging got a $700,000 loan that came with a choice of two different repayment schedules.…
A: The computation is done below:
Q: Every 15 days a company receives P10,000 worth of raw materials from its suppliers. The credit terms…
A: Number of raw materials worth P 10000 received in a year = 360/15 = 24 2/15, net 30 credit terms…
Q: Assume that a money manager is considering the buy of a $35,000 machine and that he appraises that…
A: The question is to take a decision to buy a machine based on expected interest rate earing and…
Q: Apple has purchased land for $500,000 for their new factory. They make a down payment of $100,000,…
A: Many Thanks for the Question. Bartleby's Guideline “Since you have posted a question with multiple…
Q: A company vehicle is being purchased for $55,000 and the business will put $5,000 down. If the…
A: Loan is contract between lender & borrower where lender provide funds to borrower for definite…
5.-
DO IT IN EXCEL, AND SHOW THE FORMULAS
The company purchases a machine, its cost of $726,000 will be financed with a loan at 13.8% interest for three years that requires equal semi-annual payments (
A) $185,674.92
B) None of these amounts
C) $311,662.13
D) $151,841.86
Step by step
Solved in 3 steps with 2 images
- 5.-DO IT IN EXCEL, AND SHOW THE FORMULASThe company purchases a machine, its cost of $726,000 will be financed with a loan at 13.8% interest for three years that requires equal semi-annual payments (annuities) that include principal and interest. What is the amount of the payment? A) $185,674.92 B) None of these amounts C) $311,662.13 D) $151,841.86 (Choose one option)PLEASE, PERFORM THE EXERCISE IN EXCEL AND SHOW THE FORMULAS9.-Textiles del Desierto, S.A., negotiates an industrial equipment worth $650,000.00 (20.35) cash is sold in installments, with an advance payment of 15% and the balance in a year and a half with equal semi-annual payments, charging 16½ % interest. Find the value of each of the semiannual payments or annuities. Note:In the image, this is the original exercise, it is in Spanish, but it is easy to understand. Very important Note:It is necessary that you make a solution approach and then the result. Above all, to check the procedure and/or the formulas used, especially when you use excel.K Consider a loan of $88,000 at 4% compounded annually, with 12 annual payments. Find the following. (a) the payment necessary to amortize the loan (b) the total payments and the total amount of interest paid based on the calculated annual payments (c) the total payments and total amount of interest paid based upon an amortization table. (a) The annual payment needed to amortize this loan is $. (Round to the nearest cent as needed.) (b) The total amount of the payments is $. (Round to the nearest cent as needed.) The total amount of interest paid is $. (Round to the nearest cent as needed.) (c) The total payment for this loan from the amortization table is $. (Round to the nearest cent as needed.) The total interest from the amortization table is $. (Round to the nearest cent as needed.)
- H3. The interest rate on a $6400 loan is 7% compounded semi-annually, and the loan is to be repaid by monthly payments of $155. Construct a partial amortization schedule showing the last 2 payments. Determine the total amount paid to settle the loan. Show work, not just the answer. Determine the total principal repaid. Determine the total amount of interest paid. Show work, not just the answer.(b) The company is considering purchasing a new delivery truck for $1,200,000. The intention is to obtain a 5-year loan from their bank, at an interest rate of 9% per annum. Annual payments are expected to be made on the loan. Required:i. Calculate Micron Industries’ annual payment on this loan. ii. Prepare the 5-year Amortization Schedule for this loan, clearly showing the interest and principal payment annually.A construction company plans to accelerate the payments on an equipment loan as production increases. The initial payment is $10,000 per year and the plan is to increase the payment, beginning in year 2, by an additional $1,000 each year through year 10. Determine the equivalent annual payment if the loan interest rate is 12%. Select one: O a. $13,585 Ob. $12,650 Oc. $18,650 O d. $15,485 Next page GRO3-07.06.2021 Time:14.30 Jump to... u Rabiu (Log out) N 204 14:43 AK A O 4x O ENG 24/06/2021
- A loan of $17,500.00 is repaid by making annual payments of $5,781.10 at the end of each year. If interest is 6.13% compounded annually. How many payments are required to amortize the loan? Round UP the answer to the next higher whole number (e.g. 5.12 must be entered as 6). Number of payments = whole number) PV=$ 2) (enter a 3) 4) Complete the amortization table below. Enter only POSITIVE VALUES IN THE AMORTIZATION TABLE (rounded to two decimal places). Total Payment number Payment amount Interest Paid Principal Repaid Balance 0) $17,500.00 1) FA tA I/Y= $ PMT=$ $ GA FA A SA FA GA P/Y=C/Y= GA FV=$ A GA GA EA $I need well explained answers by showing all steps and calculations, involving all formulas.. A $10 000 loan is to be repaid with semi-annual payments of $ 2500 for as long as necessary. If interest is at j12 = 12%, create a complete amortization schedule.You are offered loans from two competing lenders on the purchase of a $6.5 million property for a 5-year term (25-year amortization). Assume that payments are made ANNUALLY. The terms are outlined below: Loan 1 Loan 2 LTV 62.5% 70.0% Rate 6.375% 6.875% Fees (total) $55,000 $77,000 Calculate the incremental cost for the extra funds provided by loan 2. Hint: Remember that the loan will not be outstanding a full 25 years. ENTER YOUR ANSWER AS A DECIMAL WITH 4 PLACES. IF YOUR ANSWER
- 4. A house costs $148,000. It is to be paid off in exactly ten years, with monthly payments of $1737.54. What is the APR of this loan?A) 6.25% B) 5.25%C) 7.25%D) 8.25%(Exercise 3.24) A loan of $2400 is to be repaid by annual payments of $261 to commence at the end of the 5 th year and fo continue thereafter tor as long as necessary. Find the time and amount of the final payment, If the final payment is to be larger than tho regular payments, Assume 1=5.2% . Last payment at time_________ Last payment $______ $(engineering economic) The contractor owner applied for a loan to the bank and was approved for a loan of Rp. 1 billion with 10% interest per year with a payback period of 10 years. Refunds are paid in uniform annual installments. The borrower always pays the right installments so that after the fifth year installment is paid, the bank provides an additional loan of Rp. 500 million and reduce interest to 8% per annum. a. Draw the cash flow of the loan and its repayments over 10 years b. Determine the amount of installments each year for the first 5 years and the last 5 years