You have a project that will involve the purchase of real estate and renovation of the real estate.
your our analysis indicates the project should have an irr of 10 percent. financing will consist of a mortgage (debt) of $90,000 dollars which represents 80 percent of the financing. the pretax cost of debt is estimated to be 8.5 percent. the remaining proportion of the financing will come from selling shares of your stock portfolio. historically, your return has been 11 percent. your marginal tax rate is 21 percent.
how would excel be used to figure this out?
should you pursue the project?

Maria am corporation uses the weighted-average method in its process costing system. the baking department is one of the processing departments in its strudel manufacturing facility. in june in the baking department, the cost of beginning work in process inventory was $4,880, the cost of ending work in process inventory was $1,150, and the cost added to production was $25,200. required: prepare a cost reconciliation report for the baking department for june.

Laval produces lamps and home lighting fixtures. its most popular product is a brushed aluminum desk lamp. this lamp is made from components shaped in the fabricating department and assembled in the assembly department. information related to the 22,000 desk lamps produced annually follows. direct materials $280,000direct labor fabricating department (8,000 dlh × $24 per dlh) $192,000assembly department (16,600 dlh × $26 per dlh) $431,600machine hours fabricating department $15,200mhassembly department $20,850mhexpected overhead cost and related data for the two production departments follow. fabricating assemblydirect labor hours 150,000dlh 295,000dlhmachine hours 161,000mh 128,000mhoverhead cost $400,000 430,000required1. determine the plantwide overhead rate for laval using direct labor hours as a base.2. determine the total manufacturing cost per unit for the aluminum desk lamp using the plantwide overhead rate.3. compute departmental overhead rates based on machine hours in the fabricating department and direct labor hours in the assembly department.4. use departmental overhead rates from requirement 3 to determine the total manufacturing cost per unit for the aluminum desk lamps.

Croy inc. has the following projected sales for the next five months: month sales in units april 3,850 may 3,875 june 4,260 july 4,135 august 3,590 croy’s finished goods inventory policy is to have 60 percent of the next month’s sales on hand at the end of each month. direct material costs $2.50 per pound, and each unit requires 2 pounds. raw materials inventory policy is to have 50 percent of the next month’s production needs on hand at the end of each month. raw materials on hand at march 31 totaled 3,741 pounds. 1. determine budgeted production for april, may, and june. 2. determine the budgeted cost of materials purchased for april, may, and june. (round your answers to 2 decimal places.)