Please help show steps and formula please.

Snicks Board Shop has several questions for you that Excel can help answer.1 The company is planning for the future and would like you to prepare apresent value analysis. Using the file ch7-10, complete a present value analysis for the following situations. Save the file as ch7-10_student_name(replacing student_name with your name). Print this completed worksheet.They would like to know the following:

Snick's Board Shop
Ch 07-10
Present Value Analysis
Annuity payment required:			Year	Interest	Annuity	Investment
			0
Future need:			1
Term (in years):			2
Interest rate:			3
			4
			5
Investment value in future:			Year	Interest	Investment
			0
Current investment:			1
Interest rate:			2
Term (in years):			3
			4
			5

a. How much they would have to pay at the end of each year, assuming a 4 percent rate of return, to yield $80,000 at the end of 5 years.

b. How much they would have at the end of 5 years if they invested$73,500 today, earning 4 percent per year.

c. How much they would have at the end of 5 years if they invested$1,850 at the end of each year, earning 4 percent per year.

d. How much they would have to invest today to have $25,100 in 5 years earning 4 percent per year.

2 Snicks Board Shop is trying to better understand the behavior of their utility expenses. They have accumulated utility expenses over the last 9 months and believe hours open per month are a good predictor of expense behavior. Utility expenses include electricity, gas, and water. Use the filech7-11 to complete a cost prediction worksheet. Save the file as ch7-11_student_name (replacing student_name with your name). The work-sheet should do the following:earning 4 percent per year.

1. Using the Hi-Lo method, calculate variable cost per unit sold, fixed costs, and a prediction of utility expense when they are open 230 hours in a month.

2. Using the Least Squares/Regression method, calculate variable cost per unit sold, fixed costs, and a prediction of utility expense when they are open 230 hours in a month.

3. Display a chart of selling expense/units sold with a trend line. (Be sure to modify each axis so your scatter diagram is better displayed, as you did earlier in this chapter.)

3 During a recent year, Snicks Board Shop had sales on account of$45,000, collections of $45,500, write-offs of $800, a beginning balance in accounts receivable of $5,000, and a beginning balance in the allowance for uncollectible accounts of $300. At year end $2,400 of accounts receivable were current, $700 were 030 days past due, $300 were 3160 days past due, $200 were 6190 days past due, and $100 were over 90 days past due. The company believes 1.5 percent of sales will not be collected.They also have experience suggesting that 2 percent of all current receivables, 11 percent of receivables 030 days past due, 16 percent of receivables 3160 days past due, 25 percent of receivables 6190 days past due,and 50 percent of receivables over 90 days past due will not be collected.Using the file ch7-12, complete the allowance for uncollectible accounts analysis for both standard methods. Save the file as ch7-12_student_name(replacing student_name with your name). Print this completed worksheet.