Jump to content


Photo

Financial Report Analysis Model (FRAM) Linked 201402

Financial Report Analysis Model Excel listed company

  • Please log in to reply
2 replies to this topic

#1 lqh5961

lqh5961

    Newbie

  • CPAnet Member
  • Pip
  • 6 posts

Posted 04 March 2014 - 02:14 PM

 
 
Financial Report Analysis Model (FRAM) Linked 201402
 
Note: English version is available for every worksheet. To get it, you could unhide the columns to the right of the column in Chinese to get the column in English.
 
i have updated the model and sharing links followed.
 
Updates
 
Compared with the former version “FRAM 201401”, following are the updates in this version “FRAM 201402”. Previous version "FRAM 201401", Financial Report Analysis Model (FRAM) Shared, http://www.analystfo...cooler/91328264
 
I fell great sorry for the inconvenience and loss caused by the mistakes and poor settings.
 
“FRAM Linked” and”FRAM” are identical except that, “FRAM Linked” separate the input section from “FRAM” as a single file, and feed “FRAM” with data via links. By doing so, “FRAM Linked” would be more convenient and friendly.
 
Mistake corrections
 
1. Correct the mistakes in the formula links in worksheet “MFR”.
 
Setting changes
 
1. Adjust the formula links of Goodwill net book value and closing balance in worksheet “OFR”, to make the model more convenient.
2. Increase the exchange rate decimal digits from 4 to 5. Increase the EPS decimal digits from 2 to 4 in worksheet “OFR”, “TB”, “3FR” and “MFR”. EPS in other worksheets remain unchanged.
 
Stored on Google Drive.
 
Folder FRAM Linked 201402
 
Stored on iask of sina.com
 
FRAM Linked 201402 (.7z file. Total two files.Please install and use 7-zip (1MB) to unzip the two files together. http://www.7-zip.org/)
FRAM Linked201402.7z.001
FRAM Linked201402.7z.002
 
FRAM 201402 (.7z file. Please install and use 7-zip (1MB) to unzip. http://www.7-zip.org/)
FRAM201402.7z
 
 

FRAM Linked User Manual (Make sure read me first please)01
2nvedn4.jpg
FRAM Linked User Manual (Make sure read me first please)02
2ljnfbr.jpg
FRAM Linked User Manual (Make sure read me first please)03
119z5ky.jpg
FRAM Linked User Manual (Make sure read me first please)04
sq0668.jpg
FRAM Linked User Manual (Make sure read me first please)05
w15tl2.jpg
FRAM Linked User Manual (Make sure read me first please)06
oh4qxu.jpg
FRAM Linked User Manual (Make sure read me first please)07
30dh2k3.jpg
FRAM Linked User Manual (Make sure read me first please)08
15802ll.jpg
FRAM Linked User Manual (Make sure read me first please)09
11rf3v7.jpg

 



#2 lqh5961

lqh5961

    Newbie

  • CPAnet Member
  • Pip
  • 6 posts

Posted 04 March 2014 - 02:15 PM

FRAM Linked User Manual (Make sure read me first please)10
ehg7pt.jpg
FRAM Linked User Manual (Make sure read me first please)11
4smj3r.jpg
FRAM Linked User Manual (Make sure read me first please)12
21mgmjm.jpg
FRAM Linked User Manual (Make sure read me first please)13
2djt7xf.jpg
FRAM Linked User Manual (Make sure read me first please)14
2wgylpc.jpg
FRAM Linked User Manual (Make sure read me first please)15
ali7mp.jpg
FRAM Linked User Manual (Make sure read me first please)16
jagh9w.jpg
FRAM Linked User Manual (Make sure read me first please)17
202ic1.jpg
FRAM Linked User Manual (Make sure read me first please)18
2ljoke0.jpg


#3 lqh5961

lqh5961

    Newbie

  • CPAnet Member
  • Pip
  • 6 posts

Posted 28 March 2014 - 01:51 PM

Stored on Google Drive.
 
Folder FRAM Linked 201402
 
Folder FRAM 201402
 
Stored on iask of sina.com
 
FRAM Linked 201402 (.7z file. Total two files.Please install and use 7-zip (1MB) to unzip the two files together. http://www.7-zip.org/)
FRAM Linked201402.7z.001
FRAM Linked201402.7z.002
 
FRAM 201402 (.7z file. Please install and use 7-zip (1MB) to unzip. http://www.7-zip.org/)
FRAM201402.7z






Also tagged with one or more of these keywords: Financial Report Analysis, Model, Excel, listed company