What can the forecasting function of a spreadsheet businesses do?

Walsh company manufactures and sells one product. the following information pertains to each of the company’s first two years of operations: variable costs per unit: manufacturing: direct materials $ 25 direct labor $ 12 variable manufacturing overhead $ 5 variable selling and administrative $ 4 fixed costs per year: fixed manufacturing overhead $ 400,000 fixed selling and administrative expenses $ 60,000 during its first year of operations, walsh produced 50,000 units and sold 40,000 units. during its second year of operations, it produced 40,000 units and sold 50,000 units. the selling price of the company’s product is $83 per unit. required: 1. assume the company uses variable costing: a. compute the unit product cost for year 1 and year 2. b. prepare an income statement for year 1 and year 2. 2. assume the company uses absorption costing: a. compute the unit product cost for year 1 and year 2. b. prepare an income statement for year 1 and year 2. 3. reconcile the difference between variable costing and absorption costing net operating income in year 1.

Afinancing project has an initial cash inflow of $42,000 and cash flows of −$15,600, −$22,200, and −$18,000 for years 1 to 3, respectively. the required rate of return is 13 percent. what is the internal rate of return? should the project be accepted?

Juan's investment portfolio was valued at $125,640 at the beginning of the year. during the year, juan received $603 in interest income and $298 in dividend income. juan also sold shares of stock and realized $1,459 in capital gains. juan's portfolio is valued at $142,608 at the end of the year. all income and realized gains were reinvested. no funds were contributed or withdrawn during the year. what is the amount of income juan must declare this year for income tax purposes?