can you do this file ………………………………………………………………….

can you do this file ………………………………………………………………….
accounting_321_cash_flow_receivables___final_project_w20.xlsx

Unformatted Attachment Preview

Don't use plagiarized sources. Get Your Custom Essay on
can you do this file ………………………………………………………………….
Just from $13/Page
Order Essay

2018
To record issue
700
To record secured note to shareholder
3 year note
Issue blend of debt and equity totalling
To record
Amortize/dpr
60000
5
Note Receivable
Professional Service Revenue
To record 6-Year note @
In Exchange for Professional Service Revenue
To record purchase of
To record sale of
To record
Amortize/dpr
To Assign
Discount
Fee
Rate
50000
5
170000
0.28
0.12
0.08
Common scriptions offered
Shares
Subscription pr.
Cash received on subscriptions
Declare script dividend on
of EPS
Interest rate
To discount Note Receivable on last day of yr
Record tax expense @
2019
To record purchase of
To settle 2015 Accounts Payable
To record sale of
To record receipt of
To record receipt of
To record purchase of
To record sale of Equipment 1
To record sale of
To record
70000
To record declaration of
Record tax expense @
Accounts Receivable Aging Summary
<30 % BD % 0.55 0.02 Balance Sheet 2018 Cash Accounts Rec Allowance for bad debt Assigned Rec Subscriptions Receivable Note Receivable Note Receivable Discounted Inventory Equipment A.D. 2019 Total Income Statement Actual 2018 Target 2019 Svc Revenue Product Revenue COGS GM Depr Bad debt expense EBIT Factor Fee Loss on Note Contingent loss Gain on sale Interest Exp Interest Rev EBT Tax Net 2,019 100,000 1.0 Point Outside Funds Forecast At Revenue level required to generate Assets Increase Liability Contribution Internal Earnings Contribution Outside Funds Required Or Liabilities Retired Return on Operating Assets Single Step Formula NOPAT Net OPR Assets Two Step Formula NOPAT Sales #VALUE! Sales Net OPR Assets #VALUE! 2.0 points Cash Flow Ratios (Year 1) Income Quality Cash from Operating Activities Net Income Times Interest Earned EBIT Interest Expense Operating Cash/Total Debt Ratio Cash from Operating Activities Total Debt Current Ratio Current Assets Current Liabilities Altman Z- Score (Year 1) Weight Work Capital Total Assets 1.2 Weight Mkt Value of Equity Total Assets 0.6 Z-Score Interpretation: > 3.0
Healthy, low probability of bankrup
1.80 – 2.99
Caution
< 1.80 High probability of bankruptcy Receivables Ratios Year 2 (1.0 point) Collection Efficiency Beg Rec + Cr Sales - Ending Rec beg Rec + Cr Sales - Current Rec Bad Debt Ratio Bad debt Cr Sales Percent Current Current Rec Tot Rec Receivable/Sales Ratio Accts Rec Total Revenue Plus 60 Ratio Rec > 60 Days
Tot Rec
Accts Rec Turnover
Cr Sales
Ave Rec
Days in Receivables
Ave Rec
Daily Cr Sls
Days Sales Outstanding
Accts Rec
Cr Sales
times

2018
Cash
Common
Paid in Excess
To record issue
126,000
700 shares @
Cash
Secured Note to Shareholder
2018
Equipment
Note Payable
To record
Amortize/dpr
7,000
119,000
10 par
180 Mkt
54000
54000
180,000
60,000
60,000
7% annual
60,000 Note @
5 years ddb
2018
Note Receivable
Professional Service Revenue
125,000
125,000
To record 6-Year note @
11%
In Exchange for Professional Service Revenue
125,000
2018
Inventory
Accounts Payable
To record purchase of
2018
Accounts Receivable
Revenue
COGS
Inventory
To record sale of
2018
Equipment
Note Payable
To record
Amortize/dpr
2015
200,000
400
200,000
units @
500
315,000
315,000
180,000
360
180,000
units @
50,000
50,000 Note @
5 years SL
50,000
9% annual
875
Assigned Rec
Accts Rec
To Assign
Discount
Fee
Rate
170,000
170,000
170,000 Receivables
0.28
0.12
0.08
Cash
Fee
Payable to Factor
Cash
Loss
Discounted Note
To discount Note Receivable on last day of yr
Subscriptions rec
Common subscribable
Pd in Excess
Cash
Subscriptions rec
Common subscribable
Common
Retained Earn
Note payable shareholders
Declare script dividend on
of EPS
Interest rate
@
18%
30000
30000
shares @
0.35
343,750
units @
625
0.08
Pay largest dividend possible at year end
Interest Exp.
Secured Note
Cash
2019
Inventory
Accounts Payable
To record purchase of
2019
Accts Payable
Cash
To settle 2018 Accounts Payable
343,750
550
2019
Accounts Receivable
Revenue
COGS
Inventory
To record sale of
412,500
412,500
375
units @
1100
2019
Cash
Assigned Receivables
102000
102000
Factor Payable
Interest exp
Cash
To record receipt of
102,000.00
2019
Cash
Accts Receivables
To record receipt of
102,000
Assigned receivables
270,000
270,000
2016
TS
Cash
To record purchase of
270,000
Receivables
21120
110
21120
Treasury shares
192
2016
Cash
Equip
AD
Gain
38000
To record sale of Equipment 1
38000
60,000
7/25/2016
2016
Cash
TS
Pd in Ts
To record sale of
2016
Retained Earnings
Cash
To record
2016
14350
70 Treasure shares
70,000.00
70,000 Cash
70,000.00
dividend
205
Retained Earnings
Common Distributable
Paid in Excess
To record declaration of
10%
stock dividend @
205
Interest exp
NP shareholders
Interest Exp.
Secured Note
Cash
Question Set:
15.0 Points
Analyze and discuss options for transactions listed below:
1. Blend of debt and equity (transaction #2)
a. Impact on Balance Sheet
b. Impact on Financial Ratios
c. Impact on Altman Z-Score
d. What is the ‘cost’ of maintaining a
300,000 minimum cash balance?
e. How would key ratios and Z-Score be affected if threshold were reduced to
f. Impact on stock price, market capitalization
2. Decision to assign receivables (transaction # 8)
a. Impact on Working Capital
b. Impact on dividend potential
c. Cost/benefit trade-off of converting Receivables to immediate cash
3. Impact of script dividend (transaction #10)
a. Alt Z Score impact
b. Cost/benefit considerations
c. Discuss effect of changing % of EPS on (a) and (b) above
4. Impact of discounting note receivable at end of Year 1
a. Balance Sheet impact
b. Discount costs vs. cash requirements (reference 1d above)
5. Amount of the 2016 Cash Dividend
6. Effect of 2016 Stock Dividend
a. Permenant effect on Retained Earnings
b. Alt Z impact
c. Impact on Cash Flow ratios
2. Discuss strategic implications for:
a. Degree of Operating Leverage, DOL
b. Degree of Financial Leverage, DFL
c. Degree of Combined Leverage, DCL
3. What does the difference beween Return on Assets and Return on Operating Assest sug
about the capital structure of this firm, and what would be your recommendations to m
4. What assumptions underlie the Outside Funds Forecast, and how is the efficacy of this m
governed by stage in product/industry life-cycle?
shares @
10 par
180 mkt
e to shareholder
54,000
d equity totalling
5% annual
180,000.00
Note @
years ddb
0.07 annual
on equipment purchase
125000
125000
125000
11
sional Service Revenue
400
units @
500 on account
360
units @
875 on account
Note @
years SL
0.09 annual
on equipment purchase
Receivables
300
144
30000
shares @
0.35
@
0.18
0.08
ivable on last day of yr
0.35 paid in cash
550
units @
625
375
units @
1100
102,000.00
Assigned receivables
270,000.00
Receivables
110
Treasury shares
38000
7/25/2016
70 Treasure shares
Cash
192
205
dividend
0.1
stock dividend @
205
0.35 paid in cash
ging Summary
30 – 60
61 – 90
0.2
0.12
90+
0.15
0.36
Accounts Payable
Contingent Payable
Payable to Factor
Note payable to shareholders
Current Portion
Secured Note
Note 1
Note2
Common
Common subscribable
Common distributable
0.1
0.5
1
2018
2019
Paid in excess
TS Stock
Pd in TS
Retained Earn
Total
Cash Flows
2018
Net Income
Depr
Accts Rec
Assigned Rec
Allowance
Note Rec
Not Rec Disc
Loss add back
Gain subtract
Inventory
Accts Pay
Factor Pay
Contingent Pay
Opr Cash
Investing
Financing
Sec Note amt
Secured Note
100,000.00 Net Income
Note 1
Note 2
Note Rec Disc
Dividend
Paid in
TS
Common Subsc.
Note sharehldrs
Beginning
Net Cash
Ending
2019
Return on Assets
1.0 Point (combined)
#DIV/0!
DuPont Proof ROA
Sales
Assets
Net
Sales
#VALUE!
#VALUE!
#VALUE!

Cash FlowAdequacy
Cash from Operating Activities
Capital Expenditures + Dividends
EBIDA Coverage
EBIDA
Interest Expense
Free Operating Cash Flow/Total Debt
Cash from Operating Activities – CAPEX
Total Debt
Quick Ratio
Liquid Current Assets
Current Liabilities
Weight
Retained Earn
Total Assets
Weight
1.4
Weight

EBIT
Total Assets
3.3
Sales
Total Assets
Z – Score
1
hy, low probability of bankruptcy
probability of bankruptcy
ear 2 (1.0 point)
(2.0 Points)
Shares Outstanding
BV/Share
ROE
EPS (BV/share * ROE)
Beginning
End
EPS (Net/Shares Ost)
Payout Ratio
Plowback Ratio
Growth rate
Dividend/share
Investor return rate
Share Price
Market Capitalization
Market Value Added
0.35
Book value/share
0.35
Valuation
2018 EBIDA
2018 EBDAT
NOPAT
NOPAT (net interest, tax)
2018 EPS (Net/Shares)
2.0 Points
Between Stated and Target Income Levels for 2019
DOL
% Change Inc
% Change Vol
DFL
Present
rd
Debt
Equity
Total
Shares
BV/share
Days in
Period
365.000
Unlevered
0.1

Present
Present
EBIT
Interest
EBT
Tax
Net Income
Shares
0.1
75,000
(75,000)

Unlevered

7,500.00
(7,500)

(2,625.00)

(4,875)
EPS
At 100,000 Net EBIT
Interest
EBT
Tax
Net Income
Shares
EPS

7,500.00
(7,500.00)
(2,625.00)

(4,875.00)
Between

DFL
Present
% Change in E.P.S.
% Change in Operating Income
DFL Unlevered
% Change in E.P.S.
% Change in Operating Income
Present
Sales
EBIT
Interest
EBT
Tax
Net Income
Shares
EPS
Present
Unlevered
EBIT
Interest
EBT
Tax
Net Income
Shares
EPS
Present
Target


7,500.00
(7,500.00)
(2,625.00)
(4,875.00)
Target
7,500.00
(7,500.00)
(2,625.00)
(4,875.00)

mum cash balance?
100,000
#DIV/0!
#VALUE!
Per share value
els for 2019
#DIV/0!

#DIV/0!
#DIV/0!
DCL
Present
Percent Change in E.P.S.
Percent Change in Sales
Unlevered
Percent Change in E.P.S.
Percent Change in Sales
DCL
Present
Percent Change in E.P.S.
Percent Change in Sales
Unlevered
Percent Change in E.P.S.
Percent Change in Sales
#DIV/0!
#DIV/0!

Purchase answer to see full
attachment

Order a unique copy of this paper
(550 words)

Approximate price: $22

Basic features
  • Free title page and bibliography
  • Unlimited revisions
  • Plagiarism-free guarantee
  • Money-back guarantee
  • 24/7 support
On-demand options
  • Writer’s samples
  • Part-by-part delivery
  • Overnight delivery
  • Copies of used sources
  • Expert Proofreading
Paper format
  • 275 words per page
  • 12 pt Arial/Times New Roman
  • Double line spacing
  • Any citation style (APA, MLA, Chicago/Turabian, Harvard)

Our guarantees

Delivering a high-quality product at a reasonable price is not enough anymore.
That’s why we have developed 5 beneficial guarantees that will make your experience with our service enjoyable, easy, and safe.

Money-back guarantee

You have to be 100% sure of the quality of your product to give a money-back guarantee. This describes us perfectly. Make sure that this guarantee is totally transparent.

Read more

Zero-plagiarism guarantee

Each paper is composed from scratch, according to your instructions. It is then checked by our plagiarism-detection software. There is no gap where plagiarism could squeeze in.

Read more

Free-revision policy

Thanks to our free revisions, there is no way for you to be unsatisfied. We will work on your paper until you are completely happy with the result.

Read more

Privacy policy

Your email is safe, as we store it according to international data protection rules. Your bank details are secure, as we use only reliable payment systems.

Read more

Fair-cooperation guarantee

By sending us your money, you buy the service we provide. Check out our terms and conditions if you prefer business talks to be laid out in official language.

Read more

Calculate the price of your order

550 words
We'll send you the first draft for approval by September 11, 2018 at 10:52 AM
Total price:
$26
The price is based on these factors:
Academic level
Number of pages
Urgency

Order your essay today and save 15% with the discount code ESSAYHELP15