Question

In: Accounting

To expand its operation in Ontario, Dundar Mifflin has applied for a $3,500,000 loan from the...

To expand its operation in Ontario, Dundar Mifflin has applied for a $3,500,000 loan from the TD Bank. According to Dundar Mifflin financial analyst, the company can only afford a maximum yearly loan payment of $1,000,000. The bank has offered Dundar Mifflin the following:

Option 1: 3 year loan with an 8 percent interest rate

Option 2: 4 year loan with a 10 percent interest rate

Option 3: 5 year loan with a 12 percent interest rate

Required:

  1. Compute the loan payment under each option for year 1.
  2. Which option should the company choose?

Please provide step by step/explanation much appreciated

Solutions

Expert Solution


Related Solutions

To expand its operation in Ontario, Dundar Mifflin has applied for a $3,500,000 loan from the...
To expand its operation in Ontario, Dundar Mifflin has applied for a $3,500,000 loan from the TD Bank. According to Dundar Mifflin financial analyst, the company can only afford a maximum yearly loan payment of $1,000,000. The bank has offered Dundar Mifflin the following: Option 1: 3 year loan with an 8 percent interest rate Option 2: 4 year loan with a 10 percent interest rate Option 3: 5 year loan with a 12 percent interest rate 1.Compute the loan...
Ms. Caterina Weldon has applied for a loan from a local bank and the bank has...
Ms. Caterina Weldon has applied for a loan from a local bank and the bank has agreed to extend to her a personal loan of $ 1,500,000/= over a period of 21/2 years. This loan will be repaid in monthly installments at the end of each month over the loan period. The proposed interest rate is 14.5% p.a. Required: Prepare a loan repayments schedule for Ms. Matemo’s loan indicating: The Model Drivers    The constant payment Interest payment Principal payment,...
. Baker & Co. has applied for a loan from Trust Bank in order to invest...
. Baker & Co. has applied for a loan from Trust Bank in order to invest in several potential opportunities. In order to evaluate the firm as a potential debtor, the bank would like to compare Baker & Co. to the industry. An analyst from the Bank had complied the following ratios for two consecutive years 2008 and 2009 for Baker & Co. The results are given below. 2009 2008 Industry Avg 2009 Current Ratio 4.3 x 5.7x 5.0x Acid...
Gale & Co. has applied for a loan from the Trust Us Bank in order to...
Gale & Co. has applied for a loan from the Trust Us Bank in order to invest in several potential opportunities. In order to evaluate the firm as a potential debtor, the bank would like to compare Gale & Co. to the industry. The following are some key financial ratios                                                             2016                2017                Industry Norm(2017) Current Ratio                                      4.3X                5.7X                            5.0X Quick Ratio                                         2.1X                2.8X                            3.0X Inventory Turnover                             1.0X                1.3X                            2.2X Average Collection Period                 90days             78.3days                      90days Debt Ratio                                           33%                 28%                            ...
Baker & Co. has applied for a loan from the Trust Us Bank to invest in...
Baker & Co. has applied for a loan from the Trust Us Bank to invest in several potential opportunities. To evaluate the firm as a potential debtor, the bank would like to compare Baker & Co. to the industry. The following are the financial statements given to Trust Us Bank: Balance Sheet     12/31/13    12/31/14 Cash     $305    270 Accounts receivable     275    290 Inventory     600    580 Current assets     1,180    1,140 Plant and equipment     1,700    1,940 Less:...
Brooks Bright (BB) has applied for a loan of $800,000 to purchase a residential house from...
Brooks Bright (BB) has applied for a loan of $800,000 to purchase a residential house from Distonic Bank. BB has the option of either paying the loan on a flat fixed rated interest or floating rate based on the declining balance of the loan. On the flat fixed interest rate pricing, Distonic Bank will charge a rate of 5 % per annum. The pricing on the floating rate based on the declining balance will be Base Lending Rate (BLR) plus...
80. Zimmer, a manufacturer of modular rooms, plans to expand its operation in Landshut, Germany. The...
80. Zimmer, a manufacturer of modular rooms, plans to expand its operation in Landshut, Germany. The expansion will cost $14.5 million and is expected to generate annual net cash flows of DM4.5 million for a period of 12 years and then the operation will be sold for DM2 million. The cost of capital for the project is 14%. Using the spot exchange rate of $0.60 per DM, compute the NPV of this expansion project.        a.    $0.78 million       ...
The commercial loan operation of a financial institution has a standard for processing new loan applications...
The commercial loan operation of a financial institution has a standard for processing new loan applications in 24 hours. Table below shows the number of applications processed each day for the last 20 days and the number of applications that required more than 24 hours to complete. (can you please send me the excel file for this problem? Thanks) the question is Draw the chart to see if the system is in control or not? I am not exactly sure...
Medical Association of Orlando Inc. is borrowing $3,000,000 to expand its business. The loan will be...
Medical Association of Orlando Inc. is borrowing $3,000,000 to expand its business. The loan will be for ten years at 8% and will be repaid in equal annual installments. Please complete the amortization schedule.
Patrick and Mary wanted to become homeowners back in 2008 and applied for a loan from...
Patrick and Mary wanted to become homeowners back in 2008 and applied for a loan from a mortgage lender. Patrick and Mary's combined income was $50,000 a year and their credit history was poor. They were approved for a mortgage loan but couldn't make the payments. This is an example of a result of _______. a. inflation b. purchasing power c. a depression d. a recession
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT