Make down payment, Ms. Manifee would like to purchase a new

Make down payment

Assignment Help Financial Management

Reference no: EM131446849

Ms. Manifee would like to purchase a new condo for $105,000. She plans to make a down payment of $50,000 and to borrow the rest of the money from the bank. The bank charges an annual percentage rate of 4% compounded daily. She agrees to monthly payments to pay off the loan in 10 years.

a) Write or copy from an Excel table the amount of interest paid each month, the amount that is paid on the principal each month, and the balance remaining at the end of each month. You only need to copy the Excel table for the first 2 years of the 10-year loan. Please do not attach the Excel file as a separate file in your homework submission.

b) Assume Ms. Manifee has made 14 payments and would like to pay off the balance immediately after the 14th payment. Write down the equation or Excel formula that enables you to calculate this balance. The formula should not be recursive.

Reference no: EM131446849

Questions Cloud

Residual distribution policy : Puckett Products is planning for $5 million in capital expenditures next year. Puckett's target capital structure consists of 60 % debt and 40 % equity. If net income next year is $3 million and Puckett follows a residual distribution policy with all..

Injection-molding machine to expand its production capacity : Larson Manufacturing is considering purchasing a new injection-molding machine to expand its production capacity. There is a one-time cost of $30,000 to perform site preparation for the machine, which will occur immediately. What would be the maximum..

Which will be divided between your ira and your car payment : You are opening an IRA that earns 6% interest compounded daily. You wish to make monthly deposits into the IRA. You also want to purchase a new car for $25,000. You plan to set aside $800 every month, which will be divided between your IRA and your c..

Sometimes stratify randomization on one or more variables : Some people sometimes stratify a randomization on one or more variables. Under stratification, researchers try to make sure certain attributes are balanced across the treatment and control groups. They stratify based on attributes that are most likel..

Make down payment : Ms. Manifee would like to purchase a new condo for $105,000. She plans to make a down payment of $50,000 and to borrow the rest of the money from the bank. The bank charges an annual percentage rate of 4% compounded daily. Write or copy from an Excel..

What is the adjusted basis of the stock and rights : Bruce receives 20 stock rights in a nontaxable distribution. The stock rights have a FMV of $5,000. The 100 shares of common stock with respect to which the rights were issued have a basis of $14,000 and a FMV of $30,000. What is the adjusted basis o..

General manager of firm that manufactures skate boards : you are the general manager of a firm that manufactures skate boards and your sales have dropped by 20% because of foreign competition. You will have to lay off 150 workers out of your 500 in order to stay profitable.

Duty of loyalty : Ally is a member and a manager of a manager-managed limited liability company called Movers & You, LLC, a moving company. The main business of Movers & You, LLC, is moving large corporations from old office space to new office space in other building..

What is the net present value of the project : You are a consultant to a firm evaluating an expansion of its current business. The cash-flow forecasts (in millions of dollars) for the project are as follows: Years Cash Flow 0 – 100 1–10 + 14 On the basis of the behavior of the firm’s stock, you b..

User Account

All Pages