alternative cash flow vector code rstudio

#ALTERNATIVE CASH FLOW VECTOR CODE RSTUDIO PDF#
#ALTERNATIVE CASH FLOW VECTOR CODE RSTUDIO INSTALL#
#ALTERNATIVE CASH FLOW VECTOR CODE RSTUDIO DOWNLOAD#

Install and load the following R packages to complete this tutorial. I use tidyxl to capture Damodaran’s spreadsheets (risk premium, credit spread, unlevered beta, marginal tax rate) in a tidy fashion allowing for seamless interaction between rows and columns. It exposes cell content, position, formatting and comments in a tidy structure for further manipulation. The tidyxl package imports non-tabular data from Excel files into R. Here, I use it with magrittr so that I can express complex operations as elegant pipelines composed of simple, easily understood pieces. The rvest package makes it easy to scrape daily treasury yield curve rates from the website of the U.S.

#ALTERNATIVE CASH FLOW VECTOR CODE RSTUDIO DOWNLOAD#

The WDI package for R makes it easy to search and download the annual percentage growth rate of Gross Domestic Product (GDP) for Saudi Arabia (Indicator: NY.ZG). The World Bank makes available a large body of economic data from the World Development Indicators through its web API. This allows the Aramco’s financial accounts (e.g., gearing, capital, income statement, balance sheet) to be quickly matched with the tables it is reported on and without having to looking for the correct location in the prospectus, a behemoth weighing in at 658 pages. The fuzzyjoin package is a variation on dplyr’s join operations that allows matching not just on values that match between columns, but on inexact matching. We will use the extract_tables() function to pull out tables 42 (pg 131 – gearing), 43 (pg 132 – capital), 45 (pg 133 – income statement) and 52 (pg 144 – balance sheet) from the Saudi Aramco Prospectus. The tabulizer package provides a suite of tools for extracting data from PDFs. In this post, I valued Saudi Aramco between US$1.69 and US$1.83 trillion using the following R packages. The numbers that are laid out in the Saudi Aramco Prospectus are impressive, painting a picture of the most profitable company in the world, with almost unassailable competitive advantages. Saudi Aramco has set a price range for its listing that implies the oil giant is worth between USD $1.6 trillion and US $1.7 trillion, making it potentially the world’s biggest IPO. I recommend Business Science’s 4-Course R-Track for Business Bundle. Need to learn Data Science for Business? This is an advanced tutorial, but you can get the foundational skills, advanced machine learning, business consulting, and web application development using R, Shiny (Apps), H2O (Machine Learning), AWS (Cloud), and tidyverse (Data Science). Perform sensitivity analysis given various risks to our model. Part 2 – DCF Company Valuation: Model Saudi Aramco’s Company Valuation.

#ALTERNATIVE CASH FLOW VECTOR CODE RSTUDIO PDF#

Part 1 – Data Sources: Collect DCF input data with PDF Scraping, Web Scraping, API’s, and tidy the data into a single DCF Inputs that can be used for Part 2. Workflow for Tidy DCF Analysis and Company Valuation In this post, we’ll use the following workflow for performing and automating DCF Analysis. tidyxl – Importing non-tabular (non-tidy) Excel Data.fuzzyjoin – Joining data with inexact matching.tidyverse – An ecosystem for wrangling and visualizing data in R.

Alternative cash flow vector code rstudio