I have (4) assisgnments I need completed correctly before 7am tomorrow 1/30/17. The spreasheets and instructions are attached for ACC 306 Microcomputer Applications Excel 2013.

1. Guided Project 6-3 2. Independent Prjoect 6-6

3.Guided Project 7-3 4.Independent Prjoect 7-6

Hamilton Civic Center Item Description Purchase Price Down Payment Loan Amount Annual Percentage Rate Current Date: 1/29/2017 Payment # Beginning Balance 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! $ Term of the Loan in Years Payment Total Interest Total Principle Total Cost of the Loan - Interest PmtPrinciple Pmt #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! Total Payment Ending Balance #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! Northern Warehouse Wear-Ever Shoes Outlet Product Inventory Product Rugged Hiking Boots Comfy Walking Shoes Lazy Flip-Flops Seriously Tall Boots Glide Running Shoes Silky Bed Slippers Classy Pumps Chunky Heel Boots Sassy Slip-Ons Color Brown and Black Brown and Black Pink and White Black Green and Black White Navy Blue Brown Silver Sizes On Hand W 5-11 R 5-12 R 5-12 W 5-11 R 5-12 R 5-12 R 5-12 W 5-11 R 5-12 450 525 130 0 100 35 408 109 25 Page 1 Mens/ Womens Men Men Women Women Men Women Women Women Women Unit Cost Retail Unit Price Actual Sold $46.50 $34.25 $7.50 $42.50 $36.50 $12.50 $15.45 $32.45 $23.50 $90.00 $65.00 $14.00 $80.00 $75.00 $20.00 $30.00 $65.00 $45.00 89 125 122 67 88 46 234 34 54 Criteria Area Product Color Mens/ Sizes On Hand Womens Unit Cost Retail Unit Price Actual Sold Net Dual Bonus Income Earned Bonus Requirements Individual Product Sales (Bonus 1) All Sales (Bonus 2) $ Award 2,500.00 $ 1,500.00 $ 20,000.00 $ 750.00 Date Investment Monthly Payments Payment Amount Term in Years Rate of Return FV Omitted, Type 1 Present Value $ 2,500.00 10 6.00% Investment Periodic Payments Annual Discount Rate Initial Cost of Investment 0 Year 1st Year Return 2nd Year Return 3rd Year Return Net Present Value Investment Annual Payments (IRA) 9.5% $ (8,000.00) $ $ $ 3,000.00 4,000.00 7,000.00 Payment Amount $ (1,200.00) Term in Years 20 Rate of Return 7.0% PV and Type are Omitted 0 Future Value Banker Contacts Information First Name Vinny Louie Patti Last Name Bowman White Lynn Email Addresses Updated Email Address Monday Clemenson Imaging LLC Technician Daily Schedule Contact Name Bonna McFarland MaryAnne Vonbank Jonathan Douglas Missy Chatterton Annie Olander Patti Boyd James Lynn Hospital East Memorial Central Childrens South Point Saint Joesephs Haskins North Lakes Western River Actual Patients 4.00 5.00 2.00 6.00 8.00 3.00 4.00 Forecasted Patients 3.00 5.00 0.00 4.00 6.00 2.00 5.00 Total Page 1 Forecast Error Image Type Cardiac General OB General Cardiac OB Cardiac Categor Priority Routine 2 Emerge 1 Add on 3 Routine 2 Routine 2 Add on 3 Emerge 1 Investment Options Investment Monthly Payments Payment Amount $ 2,200.00 Term in Years 10 Rate of Return 4.50% FV 0 and Type 1 Present Value 1 Banker Contacts Information First Name McKenna Chase Gabby Carter Last Name Brand Williams Whitworth Spillim Email Addresses on resses Date Placer Hills Real Estate Mortgage Calculator Current Home Sale and Equity $ $ $ $ $ $ $ - Sale Price Payoff for Home Home Equity Payoff Other Debt to Payoff Other Debt to Payoff Other Debt to Payoff Renovations for new Home $ - Additional Income $ - Amount for down payment New Home Financi $ $ $ $ $ $ 0 0.00% #VALUE! #VALUE! Difference between Old & New House Payment Old House Payment New House Payment Difference Created for: Date: Realtor: #VALUE! #VALUE! ge Calculator New Home Financing Purchase Price Down Payment Loan Amount Loan Term Interest Rate Payment without Tax or Insurance Approximate Taxes Approximate Insurance Approx Monthly Tax & Insurance New House Payment