Income-Before-Tax Time Series for Hiwin Technologies Corp. Hiwin Technologies Corporation manufactures and sells motion control and systematic technology products. The company operates through Linear Guideways, Ballscrews, and Other segments. It offers ballscrews, Ball Spline, linear guideways, bearings, DATORKER strain wave gear, end effectors, torque motor rotary tables, and semiconductor subsystem, as well as single and multi-axis robots; and medical robots and equipment. The company provides components, and industrial robots, transmission parts, ball screws, linear slides and industrial robots. It also engages in the research, development, design, and manufacture of solar cells, electronic components, electric power supplies, electric transmission, and power distribution machinery products, as well as gear cutting tools and machinery; thread forming machinery; and sale of gear cutting tools and machinery. The company offers its products under the HIWIN brand name. Hiwin Technologies Corporation was incorporated in 1989 and is headquartered in Taichung, Taiwan.

DESCRIPTION

A banking institution requires actionable insights into mortgage-backed securities, geographic business investment, and real estate analysis. The mortgage bank would like to identify potential monthly mortgage expenses for each region based on monthly family income and rental of the real estate. A statistical model needs to be created to predict the potential demand in dollars amount of loan for each of the region in the USA. Also, there is a need to create a dashboard which would refresh periodically post data retrieval from the agencies. The dashboard must demonstrate relationships and trends for the key metrics as follows: number of loans, average rental income, monthly mortgage and owner’s cost, family income vs mortgage cost comparison across different regions. The metrics described here do not limit the dashboard to these few. Dataset Description

Variables

Description Second mortgage Households with a second mortgage statistics Home equity Households with a home equity loan statistics Debt Households with any type of debt statistics Mortgage Costs Statistics regarding mortgage payments, home equity loans, utilities, and property taxes Home Owner Costs Sum of utilities, and property taxes statistics Gross Rent Contract rent plus the estimated average monthly cost of utility features High school Graduation High school graduation statistics Population Demographics Population demographics statistics Age Demographics Age demographic statistics Household Income Total income of people residing in the household Family Income Total income of people related to the householder Project Task: Week 1

Data Import and Preparation:

Import data.

Figure out the primary key and look for the requirement of indexing.

Gauge the fill rate of the variables and devise plans for missing value treatment. Please explain explicitly the reason for the treatment chosen for each variable.

Exploratory Data Analysis (EDA):

Perform debt analysis. You may take the following steps:

Explore the top 2,500 locations where the percentage of households with a second mortgage is the highest and percent ownership is above 10 percent. Visualize using geo-map. You may keep the upper limit for the percent of households with a second mortgage to 50 percent

Use the following bad debt equation:

Bad Debt = P (Second Mortgage ∩ Home Equity Loan) Bad Debt = second_mortgage + home_equity - home_equity_second_mortgage Create pie charts to show overall debt and bad debt

Create Box and whisker plot and analyze the distribution for 2nd mortgage, home equity, good debt, and bad debt for different cities

Create a collated income distribution chart for family income, house hold income, and remaining income

Perform EDA and come out with insights into population density and age. You may have to derive new fields (make sure to weight averages for accurate measurements):

Use pop and ALand variables to create a new field called population density

Use male_age_median, female_age_median, male_pop, and female_pop to create a new field called median age

Visualize the findings using appropriate chart type

Create bins for population into a new variable by selecting appropriate class interval so that the number of categories don’t exceed 5 for the ease of analysis.

Analyze the married, separated, and divorced population for these population brackets

Visualize using appropriate chart type

Please detail your observations for rent as a percentage of income at an overall level, and for different states.

Perform correlation analysis for all the relevant variables by creating a heatmap. Describe your findings.

Project Task: Week 2

Data Pre-processing:

The economic multivariate data has a significant number of measured variables. The goal is to find where the measured variables depend on a number of smaller unobserved common factors or latent variables.

Each variable is assumed to be dependent upon a linear combination of the common factors, and the coefficients are known as loadings. Each measured variable also includes a component due to independent random variability, known as “specific variance” because it is specific to one variable. Obtain the common factors and then plot the loadings. Use factor analysis to find latent variables in our dataset and gain insight into the linear relationships in the data.

  Following are the list of latent variables:

Highschool graduation rates

Median population age

Second mortgage statistics

Percent own

Bad debt expense

Data Modeling :

Build a linear Regression model to predict the total monthly expenditure for home mortgages loan.

  Please refer deplotment_RE.xlsx. Column hc_mortgage_mean is predicted variable. This is the mean monthly mortgage and owner costs of specified geographical location.

  Note: Exclude loans from prediction model which have NaN (Not a Numb...

In 2024, the Walt Disney Company generated a revenue of nearly 34.2 billion U.S. dollars with its parks, and experiences, an increase of around 4.9 percent from the year before. The company's biggest revenue source was its entertainment segment, which generated revenues of over 41 billion U.S. dollars in 2024. This marked a growth of 1.4 percent year-on-year. The total assets of the Walt Disney Company amounted to more than 196 billion U.S. dollars in 2024.Additional info: Walt Disney Company's revenue by operating segmentIn 2023, the Walt Disney Company generated over 19 percent of its revenue through its sports segment which includes the ESPN properties. This revenue stream brought the company 17 billion U.S. dollars that year.The experiences segment was the second-largest revenue source, generating a total of 32.6 billion U.S. dollars. It is a very successful segment – Disney’s parks take the top spots in the ranking of the most visited amusement and theme parks worldwide. The Magic Kingdom Park in Bay Lake, Florida, ranked first in 2022 with 17 million visitors. The largest revenue stream – with over 40 billion U.S. dollars – was the entertainment business. This segment includes linear networks, direct-to-consumer (DTC) business and content sales and licensing. The DTC operations comprise of the company's streaming services such as Disney+, Disney+ Hotstar, and Hulu. This subsegment brought in more than five billion U.S. dollars in the last quarter of 2023.

Net-Income-Including-Non-Controlling-Interests Time Series for THK Co Ltd. THK Co., Ltd. engages in the manufacture and sale of mechanical components worldwide. The company provides linear motion (LM) guides, ball screws, ball splines, LM guide actuators, cross roller rings/ double row angular contact ring, electric actuators, linear motor actuators, cam followers, roller followers, linear bushes, LM strokes, slide packs, slide rails, cross roller guides and tables, linear ball slides, LM and flat rollers, spline nuts, screw nuts, change nuts, precision linear packs, link balls, rod ends, spherical plain bearings, lubrication accessories, and seismic isolation products. Its products are used in various applications, including machine tools, general industrial machinery, precision instruments, semiconductor and LCD manufacturing equipment, industrial robots, electronic devices, and transport systems, as well as in construction, aerospace, medical and assistive, and other manufacturing industries. The company was incorporated in 1946 and is headquartered in Tokyo, Japan.

Interest-Income Time Series for Union Tool Co. Union Tool Co. designs, manufactures, and sells of cutting tools, linear motion products, and metal machining equipment in Japan, China, Taiwan, and internationally. It offers printed circuit board (PCB) drills/routers, ULF coatings, diamond coated routers, and P series micro-hole drills; PCB tools-related equipment; carbide end mills; linear motion products; and crossed roller guide and optical glass measuring instruments. The company provides roll dies and incremental dies, rack dies, rolled products, screw manufacturing dies, coating rods, and forging tools, as well as myBeat wearable heart rate sensors and remote watching radar for small room. The company was formerly known as Union Chemical Research Co., Ltd. and changed its name to Union Tool Co. in 1971. The companywas founded in 1955 and is headquartered in Shinagawa-ku, Japan.

Based on the data of the Chinese A-share listed firms in China Shanghai and Shenzhen Stock Exchange from 2014 to 2021, this article explores the relationship between common institutional investors and the quality of management earnings forecasts. The study used the multiple linear regression model and empirically found that common institutional investors positively impact the precision of earnings forecasts. This article also uses graph neural networks to predict the precision of earnings forecasts. Our findings have shown that common institutional investors form external supervision over restricting management to release a wide width of earnings forecasts, which helps to improve the risk warning function of earnings forecasts and promote the sustainable development of information disclosure from management in the Chinese capital market. One of the marginal contributions of this paper is that it enriches the literature related to the economic consequences of common institutional shareholding. Then, the neural network method used to predict the quality of management forecasts enhances the research method of institutional investors and the behavior of management earnings forecasts. Thirdly, this paper calls for strengthening information sharing and circulation among institutional investors to reduce information asymmetry between investors and management.

Net-Income-From-Continuing-Operations Time Series for MFE MEDIAFOREUROPE NV. MFE-Mediaforeurope N.V. operates in the television industry in Italy and Spain. It is involved in the content production and third-party content acquisition; and content distribution for linear and non-linear, and free-to-air and pay-per-view television across various platforms and radio content. The company also engages in the advertising sale for television and radio operations through its concessionaires and online; and sells advertising space on managed media with cross-media coverage. In addition, it is involved in the film production and distribution, publishing, licensing and merchandising, and advertising concessions of third-party publishing houses through Digitalia and and Mediamond, as well as foreign media through Publieurope. The company was formerly known as Mediaset S.p.A. and changed its name to MFE-Mediaforeurope N.V. in November 2021. MFE-Mediaforeurope N.V. was incorporated in 1987 and is headquartered in Milan, Italy.

Interest-Income Time Series for AtriCure Inc. AtriCure, Inc. develops, manufactures, and sells devices for surgical ablation of cardiac tissue, exclusion of the left atrial appendage, and temporarily blocking pain by ablating peripheral nerves to medical centers in the United States, the Asia-Pacific, and internationally. The company offers Isolator Synergy Clamps, a single-use disposable radio frequency products; multifunctional pens and linear ablation devices, a single-use disposable RF products for the treatment of cardiac arrhythmias; cryoICE Cryoablation System that enables the user to make linear ablations of varied lengths; and EPi-Sense Systems, a single-use disposable device used for the treatment of symptomatic, drug-refractory, and long-standing persistent atrial fibrillation. It also provides cryoSPHERE probe, which provides temporary pain relief by applying cryothermic energy to targeted intercoastal peripheral nerves in the ribcage; AtriClip System, an implantable device coupled to a single-use disposable applier; LARIAT System, a solution for soft-tissue closure; Lumitip dissectors to separate tissues to provide access to key anatomical structures that are targeted for ablation; Glidepath guides for placement of clamps; and Subtle Cannula's to support access for EPi-Sense catheters. In addition, the company sells various reusable cardiac surgery instruments. It markets and sells its products through independent distributors and direct sales personnel. The company was incorporated in 2000 and is headquartered in Mason, Ohio.

Net-Income Time Series for Diodes Incorporated. Diodes Incorporated, together with its subsidiaries, manufactures and supplies application-specific standard products in the broad discrete, logic, analog, and mixed-signal semiconductor markets in Asia, Europe, and the Americas. The company offers discrete semiconductor products, such as MOSFETs, SiC MOSFETs; data line protection, power line protection, thyristers, USB Type-C protection, and transient voltage suppressors; Schottky, small signal switching, Zener, and SiC diodes; bridges, super barrier, Schottky, Schottky bridge, and fast/ultra-fast rectifiers; and bipolar, avalanche, gate driver, and pre-bias transistors. It provides analog products, including power management devices comprising AC-DC and DC-DC converters, USB power switches, low dropout, photocoupler and linear voltage regulators; standard linear devices consisting of operational amplifiers and comparators, current monitors, voltage references, and reset generators; LED lighting drivers; audio amplifiers; and sensor products, such as hall-effect sensors and motor drivers. In addition, the company offers mixed-signal products, such as high speed mux/demux, digital switches, interface, re-drivers, universal level shifters/voltage translators, clock ICs, and packet switches; standard logic products comprising low-voltage complementary metal-oxide-semiconductor (CMOS) and advanced high-speed CMOS devices; ultra-low power CMOS logic; analog switches; multichip products and co-packaged discrete, analog and mixed-signal silicon in miniature packages; and silicon and silicon epitaxial wafers used in manufacturing frequency control products and contact images sensors. It serves industrial, automotive, computing, communications, and consumer markets through direct sales, marketing personnel, independent sales representatives, and distributors. The company was incorporated in 1959 and is headquartered in Plano, Texas.

Net-Income-From-Continuing-Operations Time Series for ADEIA CORP. Adeia Inc., together with its subsidiaries, operates as a media and semiconductor intellectual property licensing company in the United States, Asia, Canada, Europe, the Middle East, and internationally. The company licenses its patent portfolios across various markets, including multichannel video programming distributors comprising cable, satellite, and telecommunications television providers that aggregate and distribute linear content over networks, as well as television providers that aggregate and stream linear content over broadband networks; over-the-top video service providers, such as subscription video-on-demand and free advertising-supported streaming service providers, as well as content providers, networks, and media companies. It also licenses consumer electronics manufacturers, which includes producers of smart televisions, streaming media devices, video game consoles, mobile devices, content storage devices, and other connected media devices; semiconductors, including providers of memory, logic, sensors, and radio frequency devices; and social media companies that allow users to stream and upload user-generated content. The company licenses its intellectual properties under the Adeia brand. Adeia Inc. was incorporated in 2019 and is headquartered in San Jose, California.

Net-Income-Including-Non-Controlling-Interests Time Series for Hangzhou Zhongya Machinery Co Ltd. Hangzhou Zhongya Machinery Co., Ltd. develops, manufactures, and sells packaging equipment and unattended vending equipment in China and internationally. The company offers filling and sealing equipment comprising linear aseptic bottle and cup filling and sealing equipment, soft bag aseptic molding filling sealing and cutting equipment, cup aseptic forming filling and sealing equipment, linear type ultraclean filling and sealing equipment for prefabricated cup, rotary preformed cup filling and sealing equipment, linear plastic bottle ultraclean filling and capping equipment, ultraclean filling and capping equipment for rotating plastic bottles, rotary plastic bottle capping equipment, equipment of blowing, filling and sealing integrated machine, and cheese bar forming filling and sealing equipment. It also provides rear intelligent packaging equipment production line products, including automatic small pack edible oil bottle blowing filling case packing, home care product bottle unscrambling filling capping case packing, gift case intelligent case erecting packing sealing, bottle product intelligent case erecting packing sealing, cup product intelligent case erecting packing sealing, pouch product intelligent case erecting packing sealing, and can product intelligent case erecting packing sealing production lines. In addition, the company offers plastic bottle blowing equipment, such as one step injection blow molding equipment, injection drawing blowing equipment, and extrusion blow molding equipment; and two step rotary stretch blow molding equipment. Hangzhou Zhongya Machinery Co., Ltd. was founded in 1992 and is based in Hangzhou, China.

Net-Income-Including-Non-Controlling-Interests Time Series for Reliance Industries Limited. Reliance Industries Limited engages in the hydrocarbon exploration and production, oil and chemicals, retail, and digital service businesses worldwide. It operates through Oil to Chemicals, Oil and Gas, Retail, Digital Services, and Others segments. The company offers refining and marketing products, including liquefied petroleum gas, propylene, naphtha, gasoline, jet/aviation turbine fuel, kerosine oil, diesel, sulphur, and petroleum coke. It also provides polymers, including high-density and low-density polyethylene (PE), linear low-density PE, homopolymer, random and impact copolymer, and polyvinyl chloride; fibre intermediates, such as purified terephthalic acid, and ethylene glycols and oxide; aromatics, such as paraxylene, ortho xylene, benzene, and linear alkyl benzene and paraffin; and textiles comprising fabrics, apparel, and auto furnishings. In addition, the company offers elastomers, such as polybutadiene rubber, styrene butadiene rubber, and butyl rubber; fibre and yarn polyesters; and bioenergy solutions, consisting of compressed biogas, and pellets and briquettes. Further, it engages in oil and gas exploration and production activities; and operates various stores comprising supermarket, hypermarket, wholesale cash and carry, specialty, and online stores, as well as stores that offer apparel, beauty and cosmetics, accessories, footwear, consumer electronics, and others. Additionally, the company operates media and entertainment platforms, and Network18 and television channels; publishes magazines; and offers highway hospitality and fleet management services. It also provides digital services, including connectivity, fibre, mobile devices, apps, business, and other digital solutions. The company was founded in 1957 and is based in Mumbai, India.

Retained-Earnings Time Series for Hangzhou Zhongya Machinery Co Ltd. Hangzhou Zhongya Machinery Co., Ltd. develops, manufactures, and sells packaging equipment and unattended vending equipment in China and internationally. The company offers filling and sealing equipment comprising linear aseptic bottle and cup filling and sealing equipment, soft bag aseptic molding filling sealing and cutting equipment, cup aseptic forming filling and sealing equipment, linear type ultraclean filling and sealing equipment for prefabricated cup, rotary preformed cup filling and sealing equipment, linear plastic bottle ultraclean filling and capping equipment, ultraclean filling and capping equipment for rotating plastic bottles, rotary plastic bottle capping equipment, equipment of blowing, filling and sealing integrated machine, and cheese bar forming filling and sealing equipment. It also provides rear intelligent packaging equipment production line products, including automatic small pack edible oil bottle blowing filling case packing, home care product bottle unscrambling filling capping case packing, gift case intelligent case erecting packing sealing, bottle product intelligent case erecting packing sealing, cup product intelligent case erecting packing sealing, pouch product intelligent case erecting packing sealing, and can product intelligent case erecting packing sealing production lines. In addition, the company offers plastic bottle blowing equipment, such as one step injection blow molding equipment, injection drawing blowing equipment, and extrusion blow molding equipment; and two step rotary stretch blow molding equipment. Hangzhou Zhongya Machinery Co., Ltd. was founded in 1992 and is based in Hangzhou, China.