Answered step by step
Verified Expert Solution
Link Copied!

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

image text in transcribed

image text in transcribed

image text in transcribed

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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

The Changing Face Of American BankingDeregulation, Reregulation, And The Global Financial System

Authors: Ranajoy Ray Chaudhuri

3rd Edition

1137365811, 9781137365811

More Books

Students also viewed these Accounting questions

Question

=+3. What is content curation and its role within social media?

Answered: 1 week ago