a) To upgrade its vehicles, the project Insignia is considering undertaking, the company is exploring the option of obtaining the $10,000,000 required via a loan from its bank for a term of 4 years, at an interest rate of 12% per annum. Monthly payments are expected to be made on the loan. Required: i. Calculate Insignia Corp.'s monthly payment on this loan. ii. Prepare the company's Amortization Schedule for the first three (3) months of this loan, clearly showing the interest and principal payments.

a) To upgrade its vehicles, the project Insignia is considering undertaking, the company is exploring the option of obtaining the $10,000,000 required via a loan from its bank for a term of 4 years, at an interest rate of 12% per annum. Monthly payments are expected to be made on the loan. Required: i. Calculate Insignia Corp.'s monthly payment on this loan. ii. Prepare the company's Amortization Schedule for the first three (3) months of this loan, clearly showing the interest and principal payments.

FINANCIAL ACCOUNTING

10th Edition

ISBN:9781259964947

Author:Libby

Publisher:Libby

Chapter1: Financial Statements And Business Decisions

Section: Chapter Questions

Problem 1Q

See similar textbooks

Similar questions

The Omega Venture Group needs to borrow to finance a project. Repayment of the loan involves payments of $2,740at the end of every six months for six years. No payments are to be made during the development period of nine years. Interest is 4% compounded monthly. (a) How much should the Group borrow? (b) What amount will be repaid? (c) How much of that amount will be interest?
A special-purpose machine toolset would cost $20,000. The toolset will befinanced by a $10,000 bank loan repayable in two equal annual installments at 10% compounded annually. The tool is expected to provide annual savings (material) of $30,000 for two years and is to be depreciated by the three-year MACRS method. This special machine tool will require annual O&M costs in the amount of $5,000. The salvage value at the end of two years is expected to be $8,000. Suppose that it is expected a 6% annual inflation during the project period. Assuming a marginal tax rate of 40% and an MARR of 20% (inflation-adjusted), what is the net present worth of this project?(a) $16,301(b) $24,558(c) $23,607(d) $18,562
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…
You recently purchased an office building for $1,950,000 using the following loan terms: 70% LTV, 20-year amortization, 6.25% interest and monthly compounding. Assuming a net operating income of $150,000 in Year 1 and income taxes equal to $11,000, what is the expected ATCF from Operations in Year 1?
Cross Ltd has bought an asset with a life span of 4 years. At the end of the 4 years, replacement of the asset will cost GH¢12,000. In this direction, the company has decided to provide for the future commitment by setting up a sinking fund account into which equal annual investment will be made at the end of each year. Interest rate on the investment will be 12% per annum. Required:i. Calculate the annual instalmentsii. Draw up the sinking fund schedule to show the growth fundiii. Assuming the first payments will be made now and 12 months thereafter, what are the annualpayments? You are required to draw up the sinking fund schedule .
A new hotel built in Banff cost $56 million to build. The owner's financing arrangements allow for quarterly payments at 8.2% compounded semi-annually over the next 20 years. The first payment is to be made today. a. What is the amount of the final payment? Number b. Calculate the principal and interest portions of the payments in the final five years. Principal (PRN) = Number Interest (INT) = Number
On January 1, 2023, Marigold Inc. signed a fixed-price contract to have Builder Associates construct a major head office facility a a cost of $4 million. It was estimated that it would take three years to complete the project. Also, on January 1, 2023, to finance the construction cost, Marigold borrowed $4 million that is repayable in 10 annual instalments of $400,000, plus interest at the rate of 10%. During 2023, Marigold made deposit and progress payments totalling $1.5 million under the contract; the weighted average amount of accumulated expenditures was $791,000 for the year. The excess amount of borrowed funds was invested in short-term securities, from which Marigold realized investment income of $24,300. For situation 1, what amount should Marigold report as capitalized borrowing costs at December 31, 2023? (If an answer is zero, please enter O. Do not leave any fields blank.) Capitalized borrowing $ 375700
The Odessa Supply Company is considering obtaining a loan from a sales finance company secured by inventories under a field warehousing arrangement. Odessa would be permitted to borrow up to $320,000 under such an arrangement at an annual interest rate of 10 percent. The additional cost of maintaining a field warehouse is $20,000 per year. Assume that there are 365 days per year. Determine the annual financing cost of a loan under this arrangement if Odessa borrows the following amounts: $320,000. Round your answer to two decimal places. % $240,000. Round your answer to two decimal places. %
Subject: Financial strategy & policy 1) A leasing contract calls for an immediate payment of $100,000 and nine subsequent $100,000 semiannual payments at six month intervals. What is the PV of these payments if the annual discount rate is 8 percent? 2) Siegefried Basset is 65 years of age and has a life expectancy of 12 more years. He wishes to invest $20,000 in an annuity that will make a level payment at the end of each year until his death. If the interest rate is 8 percent, what income can Mr. Basset to receive each year?
Your company borrows $300,000 from the investment bank for building upgrades. It agrees for a (5) years loan with annual payment of $45,000 for first four payments, and the final payment on the 5th year should be $170,000. Calculate the annual payment in the first four years, interest rate, and the final payment at year 5. |
The committee decided to secure a loan of $2,400,000 for the overall project. They got two offers from banks. - MC bank - pay in 24 months, $100,000 p/month of repayment, at an annual simple interest rate of 5% for the total loan - CS bank - pay in 16 months, $150,000 p/month of repayment at, an annual compound interest rate of 6% for the total loan The committee needs to decide which bank they should go with. So, they hired you as their financial advisor. 4. Create two amortization tables showing Payment number, Payment, Interest, Principal Reduction , Balance and total payments for Simple interest and Compound interest. 8. The city expects the population in the Residential Infrastructure area to grow exponentially at a rate of 2% per year. a. Calculate the projected population after 10 years if the current population is 50,000 (define a recurrence relation to answer this question). b. Draw a graph illustrating the population growth over 10 years. The city planning committee is…