[2b] Technicak remarks on Rate of Growth of Time Series Data : How to interprete the rate of growth of Value Added (VA) of a firm.
[2c] You may choose at least two Telecommunications Equipment Producers from among those in [2] for a comparative study: Follow
How to Work with the Excel File.
[2d] Break-even Diagram
b. Break-even Diagram Illustrated (English version):
＊Compare firms chosen and the industrial average.
The course focuses on the managerial analysis of the Japanese firms, using their recent financial statements as data and Excel for the analytical software. My Web site is also fully utilized that provides digital lecture notes and exercises (along with useful hints).
The topics include (1) what the Japanese financial statements look like, and (2) how the managerial performance of the firms may be quantified and evaluated. The four main indices for the managerial performance studied include the financial security, the profitability, the productivity, and the growth.
The students will be asked to choose one or two Japanese firms for their Excel-based managerial analysis and to work with their term paper using the software Word.
Students are strongly urged to raise questions and discuss them with the instructor during class. They are expected to enjoy working with the personal computer and, in particular, Excel and Word.
Japanese Business Management A (for 1998) [See Tables & Figures there for an overview of the recent Jpns economy (with cross-country comparison).]
Portable telephones and personal computers produced, and internet users in Japan.
Source: Asahi N.P. 1/23/00.
Why such a dramatic increase in portable phones produced in 1996?? (CIAJ Quarterly, Vol.9 Winter 1997: English version)
通信機械工業会 CIAJ (on portable phones);
日本電子機械工業会 (on Electronic Equipment);
日本電子工業振興協会 (on computers);
Access Media International
(AMI-USA specializes in IT/Internet/Communications Strategy, Venture Capital, and ...)Share prices of major elec. firms and their internet strategies
Source: Asahi N.P. 2/25/00.
Major elec. firms, general trading firms and their electronic commerce strategies involving convenience stores in Japan
Source: Asahi N.P. 2/26/00.
Telecommunications equipment produced in Japan (with introductory Excel exercises) 
[elec_78-98.zip]
Telecommunications Equipment Producers 通信機器メーカー
What corporate financial statements look like.
Japanese Electrical and Electronics Industry
Excel Files to Work With are:
[1] Financial Data Items and Names of Ratios to be Computed: See elec_78-98.zip.
[2a] Compute ratios and growth rates for all the firms in a sheet "Data7803-9803" in elec_78-98.zip, which contains full data set with ratios yet to be computed.
a. Exel file (Compressed as zip) [SpringHomework_I.zip]
[3]＊How to compute and make use of the industrial average for each year [elec_78-98_IndAvrg.zip]
Term Paper (Word File) to Work With
1. Word for Term Paper 
2. Senior Theses, Term Papers for Business Statistics (in Japanese) of Interest 
Course Descpription
| To: Top of the Frame |