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.

Expert Solution

Loan amount = $ 3,000,000
Interest rate = 8%
Loan tenure = 10 years

EMI calculation = Loan amount / Annuity of interest rate for loan period
= $ 3000000/Annuity value of 8% for 10 years
= $ 3000000/6.7101
= $ 447088.50

Year	PVF 8%
1	0.9259
2	0.8573
3	0.7938
4	0.7350
5	0.6806
6	0.6302
7	0.5835
8	0.5403
9	0.5002
10	0.4632	3000000
	6.7101	447088.4661


Amortisation table:

Year	Interest	Principal	EMI amount	Loan out standing
0				$ 3,000,000.00
1	$ 240,000.00	$ 207,088.50	$ 447,088.50	$ 2,792,911.50
2	$ 223,432.92	$ 223,655.58	$ 447,088.50	$ 2,569,255.92
3	$ 205,540.47	$ 241,548.03	$ 447,088.50	$ 2,327,707.89
4	$ 186,216.63	$ 260,871.87	$ 447,088.50	$ 2,066,836.03
5	$ 165,346.88	$ 281,741.62	$ 447,088.50	$ 1,785,094.41
6	$ 142,807.55	$ 304,280.95	$ 447,088.50	$ 1,480,813.46
7	$ 118,465.08	$ 328,623.42	$ 447,088.50	$ 1,152,190.04
8	$ 92,175.20	$ 354,913.30	$ 447,088.50	$ 797,276.74
9	$ 63,782.14	$ 383,306.36	$ 447,088.50	$ 413,970.38
10	$ 33,117.63	$ 413,970.38	$ 447,088.01	$ -

jeff jeffy answered 3 years ago

You are contemplating taking a loan to expand your business. If the loan is approved, you...

You are contemplating taking a loan to expand your business. If the loan is approved, you could increase your profit by $6,000 per month, so you do not wish to pay more than that amount in monthly loan payments. The amount you would need to borrow to implement this expansion is $300,000. The bank is offering an interest rate of 4.25% per year. What is the shortest loan duration you would accept?

DeSoto Tools Inc. is planning to expand production. The expansion will cost $3,000,000, which can be...

DeSoto Tools Inc. is planning to expand production. The expansion will cost $3,000,000, which can be financed either by bonds at an interest rate of 8 percent or by selling 60,000 shares of common stock at $50 per share. The current income statement before expansion is as follows: DESOTO TOOLS INC. Income Statement 20X1 Sales $ 3,100,000 Variable costs 620,000 Fixed costs 810,000 Earnings before interest and taxes $ 1,670,000 Interest expense 500,000 Earnings before taxes $ 1,170,000 Taxes @...

RTE Telecom, Inc. is a U.S. firm that wants to expand its business internationally. It is...

RTE Telecom, Inc. is a U.S. firm that wants to expand its business internationally. It is considering mutually exclusive potential projects in both Germany and Mexico, and the German project is expected to take six years, whereas the Mexican project is expected to take only three years. However, the three-year project is repeatable. If the cost of capital for each project is 10%, what is the difference in NPVs between the German and Mexican projects? Project: German Project: Mexican Year...

GroundPink Inc. needs $2.7 million to expand its business. To accomplish this, the firm plans to...

GroundPink Inc. needs $2.7 million to expand its business. To accomplish this, the firm plans to sell 20-year, $1,000 face value zero coupon bonds. The bonds will be priced to yield 6.25 percent with interest compounded semiannually. What is the minimum number of bonds the company must sell? Ignore all cost issues.

In order to expand its business, the management of Carroll, Inc. issued a long-term notes payable...

In order to expand its business, the management of Carroll, Inc. issued a long-term notes payable for $50,000 on January 1, 2016. The note will be paid over a 10-year period with equal annual principal payments, December 31 of each year. The annual interest rate is 12%. Prepare the journal entry for the first installment payment.

Assume the bank’s borrowing rate is 2% per annum. A business applies for 12 million loan...

Assume the bank’s borrowing rate is 2% per annum. A business applies for 12 million loan for a project and plans to repay the loan in one year. A loan officer estimates the payoff from the project will be 30 million with 70% probability and 10 million with 30% probability. If a loan defaults, on average, a bank can get 60% of the salvage value. If the bank requires 3% return on its loans, what would be the loan rate?

NewMedia Inc. is planning to expand its business globally. oOh!Media Ltd, an Australian advertising and media...

NewMedia Inc. is planning to expand its business globally. oOh!Media Ltd, an Australian advertising and media company, is among the acquisition targets NewMedia is evaluating. oOh!Media has a sizable lease portfolio. Cindy, NewMedia’s CFO, is concerned that under IFRS 16 oOh!Media’s financial results and leverage may look significantly less attractive. Cindy is familiar with the new lease accounting standard for U.S. GAAP, but has not been following the IFRS standard. She has asked your team to 1) explain the major...

Maudry is borrowing $10,000 today to fund a new small business. She has an interest-only loan...

Maudry is borrowing $10,000 today to fund a new small business. She has an interest-only loan for the first 12 months, and her first payment will be in one month. (Note: With this interest-only loan, each payment exactly equals the amount of interest accrued in the previous month.) How much will each of the first 12 payments be if the effective annual interest rate is 10%? A. $83 B. $82 C. $81 D. $80 E. $79 Warren is considering...

Roland Inc. is planning to expand their business by entering in the construction industry as a...

Roland Inc. is planning to expand their business by entering in the construction industry as a panel formwork supplier. The potential number of forthcoming projects, you forecasted that within two years, your fixed cost for producing formworks is $ 292,000. The variable unit cost for making one panel is $ 18. The sale price for each panel will be $ 50. The company’s income statement from last month is as follows: Sales Revenue Total $600,000 Per Unit $50 Variable expenses...

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...

Question