Question

In: Economics

can i get the Data of metro Nashville Area in Excel please Unemployment Median Home Price...

can i get the Data of metro Nashville Area in Excel please

Unemployment

Median Home Price

Population

Taxes

Floreclosure

GDP

Solutions

Expert Solution

Mentioned below is the data for Nashville for the parameters as asked in the question:

Unemployment Median Home Price Population Taxes Floreclosure GDP
Current unemployment rate is 2.7% as of Feb-2018 compared to 3.7% as of Feb-1017 The median home value in Nashville is $254,619. Nashville home values have gone up 12.2% over the past year and Zillow predicts they will rise 4.1% within the next year

With all municipalities, Nashville had a population of 626,600

Tax rates of

Tennessee state applies on Nashville, details of various tax rates are mentioned below

There are currently 130 properties in Nashville, TN that are in some stage of foreclosure. Home sales for February 2018 were up 437% compared with the previous month The GDP per capita of Nashville Metro Area (TN) was $59,316 in 2017

Tennessee does not tax individual wage income earned by its residents. It does, however, collect taxes on interest and dividend earnings. More on Tennessee taxes can be found in the tabbed pages below.

Personal income tax

The Tennessee income tax does not apply to salaries and wages, but most income from stocks, bonds and notes receivable is taxable at a flat rate of 6%.The first $1,250 in taxable income received by a single filer is exempt. The first $2,500 in taxable income received by a joint filer is exempt. People older than 65 and who have total income of less than $37,000 for a single filer or $68,000 for a joint filer also are exempt.

Sales taxes

Generally, the state’s sales and use tax rate is 7%. Food items, however, are taxed at 5%.

Local sales taxes up to 2.75% also are collected.

Personal and real property taxes

Tennessee does not have a homestead exemption. However, there is a property tax relief program for the elderly, disabled and veterans. Program requirements may be found at the Tennessee Comptroller’s website.

Assessments are based on a percentage of fair market value of the property as of each Jan. 1. The required percentage varies according to statutory classifications based on actual or potential use:

  • Residential property at 25%.
  • Farm property at 25%.
  • Commercial and industrial property at 40%.
  • Public utility property at 55%.
  • Business personal property at 30%.

Tax rates are expressed as an amount per $100 of assessed value and are set by the governing body of the county or city. The delinquency date is generally March 1 following the tax year, but some cities have earlier delinquency dates by private act or local ordinance.

Inheritance and estate taxes

Tennessee imposes an inheritance tax through 2015, ranging from 5.5% to 9.5% on decedents’ estates that exceed maximum single exemption limits. It was $5 million in 2015. In 2016 and future tax years, there is no inheritance tax.

Because of the phaseout of the federal estate tax credit, Tennessee’s estate tax is not imposed on estates of people who died in 2005 or later.


Related Solutions

Business Analytics Could I get the answer on a downloadable excel sheet please? if i cannot...
Business Analytics Could I get the answer on a downloadable excel sheet please? if i cannot get the downloadable file here on chegg: my email is [email protected] i can paypal $10 for the answer. Market Insights Co. (MIC) is a full-service market research company. MIC is being hired to interview registered voters in a district to gain insight into their opinions about certain issues. Each voter is to be interviewed in person. The costs of interviewing different types of voters...
How can I solve this in Excel? Please show how to solve it in excel step...
How can I solve this in Excel? Please show how to solve it in excel step by step. 1) Speedy Wheels is a wholesale distributor of bicycles for the western United States. Its Inventory Manager, Ricky Sapolo, is currently reviewing the inventory policy for one popular model — a small, one-speed girl's bicycle that is selling at the rate of 250 per month. The administrative cost for placing an order for this model from the manufacturer is $200 and the...
Can I get the excel workings of this question? WBC is currently financed using debt and...
Can I get the excel workings of this question? WBC is currently financed using debt and equity with a targeted debt to equity ratio of one (D/E = 1). Its debt financing is from three sources, overdraft, bank bills and debentures, with the ratio of overdraft to bank bills to debentures of 1:2:3. Its equity is ordinary shares. These ratios represent the long-term capital structure target for WBC. The debenture pays an annual coupon of 12 per cent per annum...
Please see answer below. Can someone please explain how to get the answer with excel? Company...
Please see answer below. Can someone please explain how to get the answer with excel? Company C is seeking for help to decide this option to choose to upgrade their current bottleneck equipment. There are two vendors and one rental option. The cost details are shown in the table below. Option Vender R Vender T Rental Initial Cost 75000 125000 0 Annual Operation Cost 28000 12000 52000 Salvage Value 0 30000 0 Estimated Life in Year 2 3 Maximum 3...
please use excel and provide the formulas The Times-Observer is a daily newspaper in Metro City....
please use excel and provide the formulas The Times-Observer is a daily newspaper in Metro City. Like many city newspapers, the TimesObserver is suffering through difficult financial times. The circulation manager is studying other papers in similar cities in the United States and Canada. She is particularly interested in what variables relate to the number of subscriptions to the paper. She is able to obtain the following sample information on 25 newspapers in similar cities. Ignore the data in the...
You have a revenue data set of a Metro Area, where a node represents an office,...
You have a revenue data set of a Metro Area, where a node represents an office, the value associated with every node is the annual revenue of this office. The data set includes 2000 offices in that Metro Area. Now, I would like to partition the Philadelphia Metro Area to 10 business sub-areas. Each of these 10 business sub-areas has one or more offices. The total anual revenue from each sub-area should equal or almost equals to others. How to...
Hi, I can't figure out this question in excel, can someone please show me the excel...
Hi, I can't figure out this question in excel, can someone please show me the excel formulas to input in order to solve for part A and B please!!!! The following table contains closing monthly stock prices for Oracle Corporation (ORCL), Microsoft Corporation (MSFT), and NVidia (NVDA) for the first half of 2017. Ticker 6/30/2017 5/31/2017 4/30/2017 3/31/2017 2/28/2017 1/31/2017 ORCL 50.14 45.39 44.96 44.61 42.59 40.11 MSFT 68.93 69.84 68.46 65.86 63.98 64.65 NVDA 144.56 144.35 104.3 108.93 101.48...
SHOW STEPS IN EXCEL PLEASE Consider the following data on price ($) and the overall score...
SHOW STEPS IN EXCEL PLEASE Consider the following data on price ($) and the overall score for six stereo headphones tested by a certain magazine. The overall score is based on sound quality and effectiveness of ambient noise reduction. Scores range from 0 (lowest) to 100 (highest). Brand Price ($) Score A 180 76 B 150 71 C 95 61 D 70 58 E 70 40 F 35 24 (a) The estimated regression equation for this data is ŷ =...
Please use the most recent data available for Home Depot. Thank you! *Excel not necessary if...
Please use the most recent data available for Home Depot. Thank you! *Excel not necessary if you can't attach, a word doc is fine* Data Case for Chapter 14: Capital Structure in a Perfect Market You work in the corporate finance division of The Home Depot and your boss has asked you to review the firm’s capital structure. Specifically, your boss is considering changing the firm’s debt level. Your boss remembers something from his MBA program about capital structure being...
Create a new workbook in Excel. Please include an input area and an answer area for...
Create a new workbook in Excel. Please include an input area and an answer area for each problem. You will have an answer for each bullet point. Formatting is up to you. Just make sure it is easy to tell where your answers are, and what equation you used in excel to get the answer. 5. Assume you have won the lottery and have the choice of (1) receiving $1,000,000 now or (2) receiving $120,000 each year for 20 years....
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT