Hello, need help with the below homework, attached please find the complete assignment and chart.

Need 3-5 paragraphs

Business Case Study Analysis - Due on Sunday March 20, 2016 by 5:00 PM into Drop Box

The City of Cannon Beach, Oregon has an annual budget cycle that begins on July 1 and ends on June 30. At the beginning of each budget year, an annual budget is established for each department. The annual budget is divided by 12 months to provide a constant monthly static budget. On June 30, all unspent budgeted monies for the budget year from the various city departments must be returned to the General Fund. Thus, if department heads fail to use their budget by year-end, they will lose it. A budget analyst prepared a chart of the difference between the monthly actual and budgeted amounts for the recent fiscal year. The chart was as follows:

Business Case Study Analysis - Due on Sunday March 20, 2016 by 5:00 PM into Drop Box The City of Cannon Beach, Oregon has an annual budget cycle that begins on July 1 and ends on June 30. At the beginning of each budget year, an annual budget is established for each department. The annual budget is divided by 12 months to provide a constant monthly static budget. On June 30, all unspent budgeted monies for the budget year from the various city departments must be returned to the General Fund. Thus, if department heads fail to use their budget by year-end, they will lose it. A budget analyst prepared a chart of the difference between the monthly actual and budgeted amounts for the recent fiscal year. The chart was as follows: (a) Interpret the chart. (b) Suggest an improvement in the budget system. Evaluate each case below, and complete the missing values or comments. CASE A CASE B CASE C CASE D CASE E CASE F Ordinary annuity ? Lump sum ? Lump sum Annuity due ? Beginning of period n/a End of period n/a ? Present value $1,580 ? $25,000 $12,746 ? ? Future value $2,114 $17,100 $31,743 ? $10,000 ? Payment $375 per year $1,250 per quarter n/a ? n/a $2,000 per month ? 8% 12% 4% 5% 6% Annually Quarterly ? Quarterly Annually Monthly 5 years ? 2 years 6 years 7 years 1 year Type Sequence Annual rate Compounding Duration CASE Type A CASE B Ordinary annuity C CASE D Lump sum Beginning of period Sequence CASE CASE E Lump sum n/a End of period $25,000 CASE F Annuity due $12,746 n/a Present value $1,580 Future value $2,114 $17,100 $31,743 $10,000 Payment $375 per year $1,250 per quarter n/a n/a $2,000 per month 8% 12% 4% 5% 6% Quarterly Annually Monthly 6 years 7 years 1 year Annual rate Compounding Duration Annually 5 years Quarterly 2 years Cedar's is an upscale restaurant that is rapidly adding locations in new markets. The primary owner is Chef Bartell, and he obtains capital for expansion by enticing people in each new target market area to invest in the restaurant. The investment program entails offering investors a "unit" of ownership for $250,000. The investment is very risky, and contemplates no return until the end of the third year. At the end of the third year, the investment is to pay each "unit" $40,000. A similar payment is to occur at the end of year four, five, and six. At the end of the seventh year, Chef Bartell has then promised to buy back the "unit" for $400,000. Assuming you desire to earn at least a 12% rate of return, should you make the investment (i.e., does the proposal have a positive net present value)? How should uncertainty factor into the evaluation? Amount Return at end of Year 1 Return at end of Year 2 Return at end of Year 3 Return at end of Year 4 Return at end of Year 5 Return at end of Year 6 Return at end of Year 7 Total present value Present Value Factor @ 12% Present Value Alpine Meadow Ski Resort is considering installing a giant snow-like carpet on a ski run. This surface would enable summer-season skiing, and generate additional net revenues (before considering the cost of the carpet or income taxes) of $1,000,000 per year. The company estimates that the carpet would have a 5-year life and no salvage value. The company is subject to a 35% tax rate. The carpet costs $3,500,000 to purchase and install, and is to be depreciated by the straight-line method. You may assume the initial investment occurs at the beginning of Year 1, and the annual cash flows occur at the end of each year. Assuming a 7% rate of return, does the investment have a positive after-tax net present value? Income Annual net revenue $ Less: Depreciation Income before tax - $ - $ Income tax (35%) Net income Cash flows - $ - $ - Evaluate each case below, and complete the missing values or comments. CASE A CASE B CASE C CASE D CASE E CASE F Ordinary annuity ? Lump sum ? Lump sum Annuity due ? Beginning of period n/a End of period n/a ? Present value $1,580 ? $25,000 $12,746 ? ? Future value $2,114 $17,100 $31,743 ? $10,000 ? Payment $375 per year $1,250 per quarter n/a ? n/a $2,000 per month ? 8% 12% 4% 5% 6% Annually Quarterly ? Quarterly Annually Monthly 5 years ? 2 years 6 years 7 years 1 year Type Sequence Annual rate Compounding Duration CASE Type A CASE B Ordinary annuity C CASE D Lump sum Beginning of period Sequence CASE CASE E Lump sum n/a End of period $25,000 CASE F Annuity due $12,746 n/a Present value $1,580 Future value $2,114 $17,100 $31,743 $10,000 Payment $375 per year $1,250 per quarter n/a n/a $2,000 per month 8% 12% 4% 5% 6% Quarterly Annually Monthly 6 years 7 years 1 year Annual rate Compounding Duration Annually 5 years Quarterly 2 years Cedar's is an upscale restaurant that is rapidly adding locations in new markets. The primary owner is Chef Bartell, and he obtains capital for expansion by enticing people in each new target market area to invest in the restaurant. The investment program entails offering investors a "unit" of ownership for $250,000. The investment is very risky, and contemplates no return until the end of the third year. At the end of the third year, the investment is to pay each "unit" $40,000. A similar payment is to occur at the end of year four, five, and six. At the end of the seventh year, Chef Bartell has then promised to buy back the "unit" for $400,000. Assuming you desire to earn at least a 12% rate of return, should you make the investment (i.e., does the proposal have a positive net present value)? How should uncertainty factor into the evaluation? Amount Return at end of Year 1 Return at end of Year 2 Return at end of Year 3 Return at end of Year 4 Return at end of Year 5 Return at end of Year 6 Return at end of Year 7 Total present value Present Value Factor @ 12% Present Value Alpine Meadow Ski Resort is considering installing a giant snow-like carpet on a ski run. This surface would enable summer-season skiing, and generate additional net revenues (before considering the cost of the carpet or income taxes) of $1,000,000 per year. The company estimates that the carpet would have a 5-year life and no salvage value. The company is subject to a 35% tax rate. The carpet costs $3,500,000 to purchase and install, and is to be depreciated by the straight-line method. You may assume the initial investment occurs at the beginning of Year 1, and the annual cash flows occur at the end of each year. Assuming a 7% rate of return, does the investment have a positive after-tax net present value? Income Annual net revenue $ Less: Depreciation Income before tax - $ - $ Income tax (35%) Net income Cash flows - $ - $