Ann would like to buy a house. it costs $2,500,000. her down payment will be $50,000. she will take out a mortgage for the remainder. it will be a 30 year, fully amortizing, frm, with constant monthly payments and monthly compounding. the annual interest rate is 4.00%. she will pay $5,000 in closing costs at origination. she will also pay 1.75% of the balance in buy-down points at origination. note: the home is bought and the loan is taken in month 0, the first payment is due in month
1. in the spreadsheet where it says "cash inflow", "outflow" and "net cash flow" you should only take into account cash flow related to the mortgage.
2. fill in the spreadsheet (sheet "fa amortization schedule") for ann. (it is called an amortization schedule or amortization calendar.)
3. compute ann's annualized irr for the mortgage in the spreadsheet. (use the net cash flow.)
(3.a) what is the annualized irr for the mortgage?
(3.b) is it higher or lower than the mortgage contract rate?
(3.c) why? in excel

Exercise 15-7 crawford corporation incurred the following transactions. 1. purchased raw materials on account $53,000. 2. raw materials of $45,200 were requisitioned to the factory. an analysis of the materials requisition slips indicated that $9,400 was classified as indirect materials. 3. factory labor costs incurred were $65,400, of which $50,200 pertained to factory wages payable and $15,200 pertained to employer payroll taxes payable. 4. time tickets indicated that $55,000 was direct labor and $10,400 was indirect labor. 5. manufacturing overhead costs incurred on account were $81,700. 6. depreciation on the company’s office building was $8,100. 7. manufacturing overhead was applied at the rate of 160% of direct labor cost. 8. goods costing $89,400 were completed and transferred to finished goods. 9. finished goods costing $76,000 to manufacture were sold on account for $105,100. journalize the transactions. (credit account titles are automatically indented when amount is entered. do not indent manually.) no. account titles and explanation debit credit (1) (2) (3) (4) (5) (6) (7) (8) (9) (to record the sale) (to record the cost of the sale) click if you would like to show work for this question: open show work