Du Pont Analysis

Inputs $-$ Income Statement

Sales $ $3,074,000\mathrm{.}00$

CGS $ $2,088,000\mathrm{.}00$

Operating Expenses $ $568,000\mathrm{.}00$

Interest Expense $ $93,000\mathrm{.}00$

Taxes $ $94,000\mathrm{.}00$

Prefered Stock Dividends $ $10,000\mathrm{.}00$

Inputs$-$ Balance$-$ Sheet

Current Assets $ $1,223,000\mathrm{.}00$

Fixed Assets $ $2,374,000\mathrm{.}00$

Current Liabilities $ $620,000\mathrm{.}00$

Long Term Debt $ $1,023,000\mathrm{.}00$

Share Hodler Equity Preffered $ $200,000\mathrm{.}00$

Sharehodler Equity $-$Common $ $1,754,000\mathrm{.}00$

Calculated Variables

Earnings Available to common Share Holders

Assets$/$Liabilities Balance OK

Total Assets or Liabilites$+$Equity

Outputs

Net Profit Margin

Total Asset Turnover

Return on Assets

Financial Leverage Multiplier

Return on Common Equity$]$

Net Profit

Margin

Common

Earnings

Sales

Time Value of Money $-$ Single Sums $59$

$64$

Inputs Inputs $34$

Present Value $100$ Future Value $10012$

Nominal Rate of Return $10\%$ Nominal Rate of Return $10\%$

Number of Years $1$ Number of Years $1$

Number of Periods per year $2$ Number of Periods per year $2$

Output Output

Future Value Present Value

Inputs Inputs

Present Value Present Value

Future Value Future Value

Nominal Rate of Return Number of Years

Number of Periods per year Number of Periods per year

Output Output

Number of years Nominal Interest Rate

Time Value of Money $-$ Annuity

Inputs Inputs

Present Value $100$ Future Value $100$

Nominal Rate of Return $10\%$ Nominal Rate of Return $10\%$

Number of Years $1$ Number of Years $1$

Number of Periods per year $2$ Number of Periods per year $2$

Periodic Payment Periodic Payment

Output Output

Future Value Present Value

Inputs Inputs

Present Value Present Value

Future Value Future Value

Nominal Rate of Return Number of Years

Number of Periods per year Number of Periods per year

Periodic Payment Period Payment

Output Output

Number of years Nominal Interest Rate

Inputs

Present Value $100$

Nominal Rate of Return $10\%$

Number of Years $1$

Number of Periods per year $2$

Periodic Payment

Future Value

Output

Periodic Payment

Loan Amortization

Inputs

Loan Amount $180000$

Nominal Rate of Return $6\%$

Number of Years $30$

Number of Periods per year $12$

Ballon Payment $0$

Output

Periodic Payment Period Beginning Balance Payment Interest Principal

$1$

$2$

$3$

$4$

$5$

$6$

$7$

$8$

$9$

$10$

$11$

$12$

$13$

$14$

$15$

$16$

$17$

$18$

$19$

$20$

$21$

$22$

$23$

$24$

$25$

$26$

$27$

$28$

$29$

$30$

$31$

$32$

$33$

$34$

$35$

$36$

$37$

$38$

$39$

$40$

$41$

$42$

$43$

$44$

$45$

$46$

$47$

$48$

$49$

$50$

$51$

$52$

$53$

$54$

$55$

$56$

$57$

$58$

$59$

$60$

$61$

$62$

$63$

$64$

$65$

$66$

$67$

$68$

$69$

$70$

$71$

$72$

$73$

$74$

$75$

$76$

$77$

$78$

$79$

$80$

$81$

$82$

$83$

$84$

$85$

$86$

$87$

$88$

$89$

$90$

$91$

$92$

$93$

$94$

$95$

$96$

$97$

$98$

$99$

$100$

$101$

$102$

$103$

$104$

$105$

$106$

$107$

$108$

$109$

$110$

$111$

$112$

$113$

$114$

$115$

$116$

$117$

$118$

$119$

$120$

$121$

$122$

$123$

$124$

$125$

$126$

$127$

$128$

$129$

$130$

$131$

$132$

$133$

$134$

$135$

$136$

$137$

$138$

$139$

$140$

$141$

$142$

$143$

$144$

$145$

$146$

$147$

$148$

$149$

$150$

$151$

$152$

$153$

$154$

$155$

$156$

$157$

$158$

$159$

$160$

$161$

$162$

$163$

$164$

$165$

$166$

$167$

$168$

$169$

$170$

$171$

$172$

$173$

$174$

$175$

$176$

$177$

$178$

$179$

$180$

$181$

$182$

$183$

$184$

$185$

$186$

$187$

$188$

$189$

$190$

$191$

$192$

$193$

$194$

$195$

$196$

$197$

$198$

$199$

$200$

$201$

$202$

$203$

$204$

$205$

$206$

$207$

$208$

$209$

$210$

$211$

$212$

$213$

$214$

$215$

$216$

$217$

$218$

$219$

$220$

$221$

$222$

$223$

$224$

$225$

$226$

$227$

$228$

$229$

$230$

$231$

$232$

$233$

$234$

$235$

$236$

$237$

$238$

$239$

$240$

$241$

$242$

$243$

$244$

$245$

$246$

$247$

$248$

$249$

$250$

$251$

$252$

$253$

$254$

$255$

$256$

$257$

$258$

$259$

$260$

$261$

$262$

$263$

$264$

$265$

$266$

$267$

$268$

$269$

$270$

$271$