Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Old MathJax webview 3 + Create a pivot table from the data on the data tab to answer the next question 5 What year had
Old MathJax webview
3 + Create a pivot table from the data on the "data" tab to answer the next question 5 What year had the most new vessles What zipcode has the most new vessles annually In Zip Code 078 what was the percentage growth between 2017 and 2018 in new vessles? In the year 2000 use conditional formatting to find the zipcodes that make up the top 10% of vessel sales that year by coloring them "green" 3 0 1 Break Even Calculations 2 An Annapolis '34 boat slip purchase cost $ 40,000.00 3 An Annapolis boat slip '34 Rental Rate $ 1,600.00 4 A Baltimore '60 boat slip purchase cost $ 74,000.004 5 A Baltimore boat slip '60 Rental Rate $ 720.00 7 What is the breakeven point for the Annapolis slip? B What is the breakeven point for the Baltimore slip? 9 Rental income payments are very similar to what concept of payments made in the class so far? 1 With an interest rate of 3% what is the Net Present Value of the payments made on the Baltimore boat slip worth after 10 years of monthly payments? 2 What is another name for "forever" in finance? 3 5 Financial Statement Questions 5 Which financial statement would record the rental revenue annually for a boat slip retal business? What is the name of the Balance Sheet for an individual person? What do we call it in casual conversation? 3 What financial statement do we use to find out how much a person made in a perticular year? 4. Create a pivot table from the data on the "data" tab to answer the next question 5 What year had the most new vessles 6 What zipcode has the most new vessles annually 7 In Zip Code 078 what was the percentage growth between 2017 and 2018 in new vessles? 8 In the year 2000 use conditional formatting to find the zipcodes that make up the top 10% of vessel sales that year by coloring them "green" 9 10 11 Break Even Calculations 12 An Annapolis '34 boat slip purchase cost $ 40,000.00 13 An Annapolis boat slip '34 Rental Rate $ 1,600.00 14 A Baltimore '60 boat slip purchase cost $ 74,000.00 15 A Baltimore boat slip '60 Rental Rate $ 720.00 16 17 What is the breakeven point for the Annapolis slip? 18 What is the breakeven point for the Baltimore slip? 19 20 Rental income payments are very similar to what concept of payments made in the class so far? 21 With an interest rate of 3% what is the Net Present Value of the payments made on the Baltimore boat slip worth after 10 years of monthly payments? 22 What is another name for "forever" in finance? 23 24 25 Financial Statement Questions 26 Which financial statement would record the rental revenue annually for a boat slip retal business? 27 What is the name of the Balance Sheet for an individual person? What do we call it in casual conversation? 28 What financial statement do we use to find out how much a person made in a perticular year? 20 D 3 1 2 1 1 1 1 1 Purchase Year ZipCodeFirst3 NewVessels 2 2000 000 3 2000 007 2000 010 5 D01011 6 2000 014 7 2000 019 8 2000 020 9 2000 021 + 10 2000 025 11 2000 028 12 2000 030 13 2000 032 14 2000 035 15 2000 037 16 2000 038 17 2000 040 18 19 2000 045 20 2000 048 21 2000 050 1 1 2 - N N 1 1 1. 2 2000 044 1 N 1 ALFA 3 + Create a pivot table from the data on the "data" tab to answer the next question 5 What year had the most new vessles What zipcode has the most new vessles annually In Zip Code 078 what was the percentage growth between 2017 and 2018 in new vessles? In the year 2000 use conditional formatting to find the zipcodes that make up the top 10% of vessel sales that year by coloring them "green" 3 0 1 Break Even Calculations 2 An Annapolis '34 boat slip purchase cost $ 40,000.00 3 An Annapolis boat slip '34 Rental Rate $ 1,600.00 4 A Baltimore '60 boat slip purchase cost $ 74,000.004 5 A Baltimore boat slip '60 Rental Rate $ 720.00 7 What is the breakeven point for the Annapolis slip? B What is the breakeven point for the Baltimore slip? 9 Rental income payments are very similar to what concept of payments made in the class so far? 1 With an interest rate of 3% what is the Net Present Value of the payments made on the Baltimore boat slip worth after 10 years of monthly payments? 2 What is another name for "forever" in finance? 3 5 Financial Statement Questions 5 Which financial statement would record the rental revenue annually for a boat slip retal business? What is the name of the Balance Sheet for an individual person? What do we call it in casual conversation? 3 What financial statement do we use to find out how much a person made in a perticular year? 4. Create a pivot table from the data on the "data" tab to answer the next question 5 What year had the most new vessles 6 What zipcode has the most new vessles annually 7 In Zip Code 078 what was the percentage growth between 2017 and 2018 in new vessles? 8 In the year 2000 use conditional formatting to find the zipcodes that make up the top 10% of vessel sales that year by coloring them "green" 9 10 11 Break Even Calculations 12 An Annapolis '34 boat slip purchase cost $ 40,000.00 13 An Annapolis boat slip '34 Rental Rate $ 1,600.00 14 A Baltimore '60 boat slip purchase cost $ 74,000.00 15 A Baltimore boat slip '60 Rental Rate $ 720.00 16 17 What is the breakeven point for the Annapolis slip? 18 What is the breakeven point for the Baltimore slip? 19 20 Rental income payments are very similar to what concept of payments made in the class so far? 21 With an interest rate of 3% what is the Net Present Value of the payments made on the Baltimore boat slip worth after 10 years of monthly payments? 22 What is another name for "forever" in finance? 23 24 25 Financial Statement Questions 26 Which financial statement would record the rental revenue annually for a boat slip retal business? 27 What is the name of the Balance Sheet for an individual person? What do we call it in casual conversation? 28 What financial statement do we use to find out how much a person made in a perticular year? 20 D 3 1 2 1 1 1 1 1 Purchase Year ZipCodeFirst3 NewVessels 2 2000 000 3 2000 007 2000 010 5 D01011 6 2000 014 7 2000 019 8 2000 020 9 2000 021 + 10 2000 025 11 2000 028 12 2000 030 13 2000 032 14 2000 035 15 2000 037 16 2000 038 17 2000 040 18 19 2000 045 20 2000 048 21 2000 050 1 1 2 - N N 1 1 1. 2 2000 044 1 N 1 ALFA
Step 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