Prepare a personal budget for one month. be sure to think through your sources of income and expenses. be as detailed as you wish; but include cells that calculate the following: income (which calculates the sum of all income sources), expenses (which calculates the sum of all expenses), and savings (which calculates the difference between the total income and expenses). after completing your budget, complete the tasks to create named ranges that reference the important cells outlined above.

Franklin painting company is considering whether to purchase a new spray paint machine that costs $4,800. the machine is expected to save labor, increasing net income by $720 per year. the effective life of the machine is 15 years according to the manufacturer’s estimate. required determine the unadjusted rate of return based on the average cost of the investment.

Lindon company is the exclusive distributor for an automotive product that sells for $30.00 per unit and has a cm ratio of 30%. the company’s fixed expenses are $162,000 per year. the company plans to sell 20,200 units this year. required: 1. what are the variable expenses per unit? (round your "per unit" answer to 2 decimal places.) 2. what is the break-even point in unit sales and in dollar sales? 3. what amount of unit sales and dollar sales is required to attain a target profit of $72,000 per year? 4. assume that by using a more efficient shipper, the company is able to reduce its variable expenses by $3.00 per unit. what is the company’s new break-even point in unit sales and in dollar sales? what dollar sales is required to attain a target profit of $72,000?

The hartman family is saving $400 monthly for ronald's college education. the family anticipates they will need to contribute $20,000 towards his first year of college, which is in 4 years .which best explain s whether the family will have enough money in 4 years ?