Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Write a formula in cell Financial!C6 to determine the Annual Interest Rate for the Panasonic Lumix in Row 6. The interest is compounded monthly PROBLEM
Write a formula in cell Financial!C6 to determine the Annual Interest Rate for the Panasonic Lumix in Row 6. The interest is compounded monthly
PROBLEM DESCRIPTION After you computerized the data you collected on the cameras your friends own, you analyzed some purchasing options for them to upgrade their cameras with the following worksheets. Photo - This worksheet includes the first names of the camera owners, the camera brand (company), the camera model, the number of megapixels (if the megapixels are under 15, then it is suggested to upgrade the camera), whether or not a lens is included with the purchase (upgrade) of a new camera, the cost of the corresponding lens, the trade in value (if any), the accessory package for the camera brand (if any), and the type of photography class that comes with the camera Lens - This worksheet includes the cost of the lens for camera brands that do not have the "Lens Included" Trade In - Your friends may have a chance to trade in their current camera model and receive a trade in value (based on the number of megapixels) towards the purchase of a new camera. Not all the camera models can be traded in. The number of megapixels range from 10.00-14.99. 15.00-19.99 and 20.00 or higher Packages - Canon, Sony, and Nikon Cameras come with camera packages that may include a memory card battery charger, editing software, or tripod. If the accessory is included in the package, it is indicated by a TRUE value Class - All purchases (upgrades) come with the opportunity to take a photography class. There are specific classes for the different camera brands. Financial - This worksheet shows different financing options different camera brands and camera models Make sure your formulas work if any of the input data changes. Cells shaded in grey on the worksheet page provided represent data that is given in the problem (input data). Use cell references wherever possible. Failure to do so will result in a loss of points. lo D F G EXCEL-LENT PHOTOGRAPHY Camera Camera Lens Suggested Trade in Megapixels Accessory Lens Included Photo Class 2 Name Brand Model to Upgrade Cost Value Package 3 Jacob Canon SD 223 FALSE Camera Only $349.99 $ 300.00 Portrait 4 Andrew Canon Rebel 10 TRUE Lens Included $ None Portrait 5 Kathleen Sony Alpha 14.2 TRUE Camera Only $298.00 $ 50.00 8 Food Photography 6 Rose Sony Alpha 14.2 TRUE Camera Only $298.00 S 50.00 Food Photography 7 Patrick Polaroid 15408 16 FALSE Lens Included $ None No Package Photobooth 5 Jessica Canon 5D 22.3 FALSE Camera Only $349.99300.00 Portrait 3 Daniel Sony Alpha 142 TRUE Camera Only $298.00 50.00 Food Photography 10 Phillip Canon 10 18 FALSE Camera Only $349.99 $ 250.00 A Portrait 11 Derek Canon Rebel 10 TRUE Lens Included s - None A Portrait 12 Joseph Panasonic Lumix 16.05 FALSE Lens Included $ 150.00. NO Package Landscape 1 Kiley Nikon 080 10.2 TRUE Camera Only $496.95 $150,00 Black and White 14 Rachel Panasonic Lumix 16.05 FALSE Lens Included $ 150,00 No Package Landscape 15 Michael Nikon 080 10.2 TRUE Camera Only $19.95 $150.00 Black and White 15 Jonathan Nikon D5100 16.2 FALSE Camera Only 54962953 200.00 Black and White Photo SISU - 0 Trade in Value 2 Megapixels Camera Model 0.14.99 15-20.99 21-25.00 Camera Brand 1D $ 150.00 $ 250.00 50.00 Canon SD $ 100.00 $ 200.00 $300.00 Canon Alpha $50.00 5150.00 $250.00 Sony 2 Lumix 550.00 5150.00 $250.00 Panasonic 000 $ 150.00 S 250.00 $350.00 Nikon 05100 $ 100,00 200.00 100.00 NON Trade In 1 2 3 4 5 6 A Camera Brand Nikon Canon Sony Polaroid Panasonic 8 Photo Class Black and White Portrait Food Photography Photobooth Landscape Class 1 Camera Brand Lens Cost Nikon 496.95 Canon 349.99 D Sony 298.00 Panasonic 147.99 Lens Camera Brands Canon Cameras Sony Cameras Nikon Cameras D Package Memory Charger Software Tripod TRUE TRUE TRUE TRUE B TRUE TRUE FALSE FALSE TRUE TRUE TRUE FALSE D5100 1.WS kon Trade in D A Camera Brand 1 2 B Nikon 496.95 Canon 349.99 Sony 298.00 E Panasonic 147.99 Lens Cost Lens 1 2 3 4 A Camera Brands Canon Cameras Sony Cameras Nikon Cameras B D Package Memory Charger Software Tripod A TRUE TRUE TRUE TRUE 8 TRUE TRUE FALSE FALSE c TRUE TRUE TRUE FALSE Packages D Years A 1 Financing Options 2 Cameras Camera Cost 3 Canon 5D Mark IV DSLR 3 2.499.00 4 Nikon 26 Mirrorless Camera $ 1,843.90 5 Sony Alpha 6600 Mirrorless $ 1,198.00 6 Panasonic Lumix DOGHS $ 1.297.99 Amount Rachel will finance aftertrade in AP compounded quarterly for 7 years with $100 quarterly paymenti. $99.49 8 Offers New Class on Accessories New Clasa APR 5 43 4X 3% Payment 5 15300) $ (54.00 5 (51.761 5 (31.03 4 3 2 3 Financial 2 31 Camera Brands Pack Canon Cameras Sony Cameras B Nikon Cameras Memory Charger TRUE TRUE TRUE TRUE TRUE TRUE Software Tripod TRUE TRUE FALSE FALSE TRUE FALLE Packages Financing Options Camera Cost 2.499.00 $ 130 $ 1.198.00 3 APR SX 4 1 2 Cameras 3 Canon 5D Mark IVOSUR 4 Nikon 26 Mirrorless Camera 5 Sony Alpha G Minor 6 Panasonic DCGHS Amount Rachel will finance aher trade in 3 APR compounded quarterly for 7 years with $100 quarterly payments Offer News on Accesso? Payment 5 8. 5 S 15. 5 03 Years 4 3 1200 3 3 $933.49 New Financial Write a formula in cell FinanciallC6 to determine the Annual interest Rite for the Panasonic Lumix in Row 6. The interest is compounded monthly FRATELE 12.06. 86.0.0) "12 RATELE 12.05.30) / 12 RATEE012. DO 30. 0.012 RATEEG13. 6.B012 PROBLEM DESCRIPTION After you computerized the data you collected on the cameras your friends own, you analyzed some purchasing options for them to upgrade their cameras with the following worksheets. Photo - This worksheet includes the first names of the camera owners, the camera brand (company), the camera model, the number of megapixels (if the megapixels are under 15, then it is suggested to upgrade the camera), whether or not a lens is included with the purchase (upgrade) of a new camera, the cost of the corresponding lens, the trade in value (if any), the accessory package for the camera brand (if any), and the type of photography class that comes with the camera Lens - This worksheet includes the cost of the lens for camera brands that do not have the "Lens Included" Trade In - Your friends may have a chance to trade in their current camera model and receive a trade in value (based on the number of megapixels) towards the purchase of a new camera. Not all the camera models can be traded in. The number of megapixels range from 10.00-14.99. 15.00-19.99 and 20.00 or higher Packages - Canon, Sony, and Nikon Cameras come with camera packages that may include a memory card battery charger, editing software, or tripod. If the accessory is included in the package, it is indicated by a TRUE value Class - All purchases (upgrades) come with the opportunity to take a photography class. There are specific classes for the different camera brands. Financial - This worksheet shows different financing options different camera brands and camera models Make sure your formulas work if any of the input data changes. Cells shaded in grey on the worksheet page provided represent data that is given in the problem (input data). Use cell references wherever possible. Failure to do so will result in a loss of points. lo D F G EXCEL-LENT PHOTOGRAPHY Camera Camera Lens Suggested Trade in Megapixels Accessory Lens Included Photo Class 2 Name Brand Model to Upgrade Cost Value Package 3 Jacob Canon SD 223 FALSE Camera Only $349.99 $ 300.00 Portrait 4 Andrew Canon Rebel 10 TRUE Lens Included $ None Portrait 5 Kathleen Sony Alpha 14.2 TRUE Camera Only $298.00 $ 50.00 8 Food Photography 6 Rose Sony Alpha 14.2 TRUE Camera Only $298.00 S 50.00 Food Photography 7 Patrick Polaroid 15408 16 FALSE Lens Included $ None No Package Photobooth 5 Jessica Canon 5D 22.3 FALSE Camera Only $349.99300.00 Portrait 3 Daniel Sony Alpha 142 TRUE Camera Only $298.00 50.00 Food Photography 10 Phillip Canon 10 18 FALSE Camera Only $349.99 $ 250.00 A Portrait 11 Derek Canon Rebel 10 TRUE Lens Included s - None A Portrait 12 Joseph Panasonic Lumix 16.05 FALSE Lens Included $ 150.00. NO Package Landscape 1 Kiley Nikon 080 10.2 TRUE Camera Only $496.95 $150,00 Black and White 14 Rachel Panasonic Lumix 16.05 FALSE Lens Included $ 150,00 No Package Landscape 15 Michael Nikon 080 10.2 TRUE Camera Only $19.95 $150.00 Black and White 15 Jonathan Nikon D5100 16.2 FALSE Camera Only 54962953 200.00 Black and White Photo SISU - 0 Trade in Value 2 Megapixels Camera Model 0.14.99 15-20.99 21-25.00 Camera Brand 1D $ 150.00 $ 250.00 50.00 Canon SD $ 100.00 $ 200.00 $300.00 Canon Alpha $50.00 5150.00 $250.00 Sony 2 Lumix 550.00 5150.00 $250.00 Panasonic 000 $ 150.00 S 250.00 $350.00 Nikon 05100 $ 100,00 200.00 100.00 NON Trade In 1 2 3 4 5 6 A Camera Brand Nikon Canon Sony Polaroid Panasonic 8 Photo Class Black and White Portrait Food Photography Photobooth Landscape Class 1 Camera Brand Lens Cost Nikon 496.95 Canon 349.99 D Sony 298.00 Panasonic 147.99 Lens Camera Brands Canon Cameras Sony Cameras Nikon Cameras D Package Memory Charger Software Tripod TRUE TRUE TRUE TRUE B TRUE TRUE FALSE FALSE TRUE TRUE TRUE FALSE D5100 1.WS kon Trade in D A Camera Brand 1 2 B Nikon 496.95 Canon 349.99 Sony 298.00 E Panasonic 147.99 Lens Cost Lens 1 2 3 4 A Camera Brands Canon Cameras Sony Cameras Nikon Cameras B D Package Memory Charger Software Tripod A TRUE TRUE TRUE TRUE 8 TRUE TRUE FALSE FALSE c TRUE TRUE TRUE FALSE Packages D Years A 1 Financing Options 2 Cameras Camera Cost 3 Canon 5D Mark IV DSLR 3 2.499.00 4 Nikon 26 Mirrorless Camera $ 1,843.90 5 Sony Alpha 6600 Mirrorless $ 1,198.00 6 Panasonic Lumix DOGHS $ 1.297.99 Amount Rachel will finance aftertrade in AP compounded quarterly for 7 years with $100 quarterly paymenti. $99.49 8 Offers New Class on Accessories New Clasa APR 5 43 4X 3% Payment 5 15300) $ (54.00 5 (51.761 5 (31.03 4 3 2 3 Financial 2 31 Camera Brands Pack Canon Cameras Sony Cameras B Nikon Cameras Memory Charger TRUE TRUE TRUE TRUE TRUE TRUE Software Tripod TRUE TRUE FALSE FALSE TRUE FALLE Packages Financing Options Camera Cost 2.499.00 $ 130 $ 1.198.00 3 APR SX 4 1 2 Cameras 3 Canon 5D Mark IVOSUR 4 Nikon 26 Mirrorless Camera 5 Sony Alpha G Minor 6 Panasonic DCGHS Amount Rachel will finance aher trade in 3 APR compounded quarterly for 7 years with $100 quarterly payments Offer News on Accesso? Payment 5 8. 5 S 15. 5 03 Years 4 3 1200 3 3 $933.49 New Financial Write a formula in cell FinanciallC6 to determine the Annual interest Rite for the Panasonic Lumix in Row 6. The interest is compounded monthly FRATELE 12.06. 86.0.0) "12 RATELE 12.05.30) / 12 RATEE012. DO 30. 0.012 RATEEG13. 6.B012Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started