I need help with the following question. Particularly the formula questions. Tha
ID: 3199637 • Letter: I
Question
I need help with the following question. Particularly the formula questions. Thank you in advance.
Acct 104 ASSGN1 MATH Your Name Here (cell A3) CURRENT DATE 12/31/17 DATE OF DEPR CURRENT AGE COST FMV TODAY 4.51 S 48,50046,500 2.96 S 65,000 54,000 7.51 S 99,000 $ 96,000 6.76 S 56,500 28,000 14.85 S 45,500 29,500 6.42 S 86,500$ 71,000 S 401,000 325,000 UTO PURCHASE LIFE Ford Mustang Boss Chevy Corvette Audi R8 Infinity G37 Acura NSX Tesla Roadster Base 06/30/13 01/15/15 06/30/10 04/01/11 03/01/03 08/01/11 INSTRUCTIONS-score is based on 60% accuracy (formulas, instructions & requirements) and 40% presentation/formatting TH Create the spreadsheet above (exactly as you see it). Formatting must be similar color and layout. Use Arial 10 pt font. Center the headings in the cells Put your name where it says "Your Name Here" in cell A3. ACCT 104 goes in cell A1, and ASSGN1 (MATH) goes in cell A2. 2 3 Start the column headings in cell B6. The CURRENT DATE is in row 5 After you enter the headings in row 6, enter all the data as you see it for AUTO, DATE OF PURCHASE, and DEPR LIFE starting in cell B7. Format dates as DD/MM/YY Calculate the Current Age cells using a formula that subtracts the Date of Purchase from the Current Date. Make sure to show the amount in years Enter the COST (which is the purchase price) data and FMV (which is the value today) data as displayed and sum each column using SUM function. Make sure to format numbers and totals properly 7 Name the sheet "MATH 1". Make sure sheet will print to one page 8 Use proper footer formatting for full credit (based on File & Sheet Naming Lecture) 9 Set your print range to landscape and make sure it will print to one page if you were to actually print (do a print preview) 10 Save the file following the file naming conventions per that lecture with the assignment name portion as "MATH MATH2 Copy MATH1 into a new sheet and name it MATH2 using the "Copy/Move Sheet" make sure to copy not move. You have two sheets now In a new column "H", title the column FMVICOST. For each Auto, divide FMV by COST and format these cells as a percentage In a new column, "T", title the columns ANNUAL DEPR. For each Auto, divide COST by DEPRECIABLE LIFE. This becomes the annual depreciation. Fomat and SUM 4 Make sure your print preview still prints to one page 5 Resave your file. You have two sheets now MATH 1 of 3Explanation / Answer
Assign 2
Current Date 12/31/17
Annual dpreciation
= Cost/ Depr life
$46500/48500
= 95.88%
$48500/7
=$6928.57
$54000/$65000
=83.08%
Assign 3
Sum of Red team sales Divided
by Sum of Blue team sales.
Percent bonus of all Red team compared to total bonus.
Assign 4
Auto Date of purchase Depr life Current age cost FMV today FMV/CostAnnual dpreciation
= Cost/ Depr life
Ford Mustang Boss 06/30/13 7 4.51 $48500 $46500$46500/48500
= 95.88%
$48500/7
=$6928.57
Chevy Corvette 01/15/15 7 2.96 $65000 $54000$54000/$65000
=83.08%
$65000/7 =$9285.71 Audi R8 06/30/10 7 7.51 $99000 $96000 96.97% $14142.86 Infinity G37 04/01/11 7 6.76 $56500 $28000 49.56% $8071.43 Acura NSX 03/01/03 14.85 $45500 $29500 64.84% $6500 Tesla Roadster Base 08/01/11 7 6.42 $86500 $71000 82.08% $12357.14 $401000 $325000 $50357.14