saveToSheet: The saveToSheet function

In ksyan/CreddaLeases:

Description

This function writes the results into an excel spreadsheet and saves it

Usage

saveToSheet(file = NULL, yrdata = test.yrSummary,
  mthdata = test.mthSummary, mth.idata = test.incomeSummary,
  avg.data = test.average.lease, assumptions = default.constants.table,
  d.assumptions = default.int.lev, emp.data = default.employees,
  growth.data = default.growth.rates, d.rate = norm.default.rate)

Arguments

file,	the name of the file the sheet will be saved as. If null the file won't be esaved and the workbook will be returned.
yrdata,	cash flow information by year, from the yrSummary function
mthdata,	cash flow information by year, from the mthSummary function
mth.idata,	incomeSummary information, from mthIncomeSummary function
avg.data,	data representing an average lease, from the calc.average function
assumptions,	constants represented in the original data frame form
d.assumptions,	constants related to interest and leverage in original data frame form
emp.data,	data on employees
growth.data,	growth.rates data
d.rate,	default rate expressed as length 1000 vector with numbers between 0 and 1

Value

a data frame with debt metrics added on to cash flow metrics

ksyan/CreddaLeases documentation built on May 20, 2019, 7:04 p.m.