Spreadsheet Problem. Use the Ch7_Rent_vs_Own worksheet in the Excel workbook provided on the website. Determine the after-tax IRR for owning versus renting in each of the five years with the following changes in the original assumptions in the spreadsheet: a. The homeowner has a 15 percent marginal tax rate instead of 28 percent. b. Rents and property values will not increase over the five years. c. The loan amount is $105,000 instead of $120,000. d. The initial rent for year 1 is $15,000 instead of $12,000.

Special order carson manufacturing, inc., sells a single product for $36 per unit. at an operating level of 8,000 units, variable costs are $18 per unit and fixed costs $10 per unit. carson has been offered a price of $20 per unit on a special order of 2,000 units by big mart discount stores, which would use its own brand name on the item. if carson accepts the order, material cost will be $3 less per unit than for regular production. however, special stamping equipment costing $4,000 would be needed to process the order; the equipment would then be discarded. assuming that volume remains within the relevant range, prepare an analysis of differential revenue and costs to determine whether carson should accept the special order. use a negative sign with answer to only indicate an income loss from special order; otherwise do not use negative signs with your answers.