Interest deduction for tax purposes in first year of loan

Assignment Help Financial Management

Reference no: EM131456813

Please show how do do in excel and show how you got the numbers with formulas and the seperate parts for each of the 4 questions

1. Your firm borrows $150,000 to expand the current offices. The bank agrees to a loan term of 4 years, with quarterly payments. The APR is 8%. Create an amortization table for the loan, showing the interest and principal payments each month for the entire term of the loan. (In Excel. show formulas)

2. Using the information from Q1, what will be the interest deduction for tax purposes in the first year of the loan?

3. You just deposited $2,500 in a bank account that pays a 4.0% nominal interest rate, compounded quarterly. If you also add another $5,000 to the account one year (4 quarters) from now and another $7,500 to the account two years (8 quarters) from now, how much will be in the account three years (12 quarters) from now?

4. Your uncle will sell you his bicycle shop for $250,000, with ‘seller financing,’ at a 6.0% APR. The terms of the loan would require you to make 12 equal end-of-month payments per year for 4 years, and then make an additional final (balloon) payment of $50,000 at the end of the last month. What are your equal monthly payments?

Reference no: EM131456813

Questions Cloud

Using before-tax costs for all components : The WACC is calculated using before-tax costs for all components. The after-tax cost of debt usually exceeds the after-tax cost of equity.

Each year after retirement at each retirement age : If her investments continue to earn the same rate, how much will she be able to withdraw at the end of each year after retirement at each retirement age?

Compute the firms operating profit margin : Last year, the Allen Corporation had sales of $12.3 million with a cost of goods sold of $3,750,000. Compute the firm’s operating profit margin.

What is the dividend they predict to pay out : Consider the following simplified financial statements for the Equity Inc.: What is the dividend they predict to pay out?

Interest deduction for tax purposes in first year of loan : what will be the interest deduction for tax purposes in the first year of the loan?

What is the equivalent value of this series at beginning : Consider a series of $141 end-of-period CFs spanning 2013-2027. What is the equivalent value of this series at the beginning 2013?

Deduction during the entire duration of her education : Cindy attended State University during 2011-2015. She lived at home and was claimed by her parents as a deduction during the entire duration of her education.

Firm is planning next years capital budget and projects : The firm is planning next year's capital budget and projects its net income at $75,000,000 and its payout ratio is 40 percent.

Compute the cost of capital for the individual components : Compute the cost of capital for the individual components in the capital structure.

User Account

All Pages