Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Review and analyze each proposed investment, using NPV and IRR. Set up a detailed cash flow table showing total cash flows for each year of
Review and analyze each proposed investment, using NPV and IRR. Set up a detailed cash flow table showing total cash flows for each year of the project. Use Excel
| Arme Botanique Income Statement | Arme Botanique Balance Sheet | ||||||||||
| In $000's | In $000's | ||||||||||
| 2021 | 2022 | 2021 | 2022 | ||||||||
| Sales | $4,760.00 | $5,142.00 | Cash | $105.00 | $127.00 | ||||||
| CGS | $1,190.00 | $1,289.00 | ST Investments | $100.00 | $200.00 | ||||||
| Gross Profit = Sales - CGS | $3,570.00 | $3,853.00 | Account Receivables | $940.00 | $1,043.00 | ||||||
| Inventory | |||||||||||
| Depreciation | $75.00 | $120.00 | Finished Goods | $1,175.00 | $1,350.00 | ||||||
| SG&A | $1,428.00 | $1,542.60 | WIP | $442.00 | $598.00 | ||||||
| Other Expenses | $476.00 | $488.49 | $2,762.00 | $3,318.00 | |||||||
| EBIT = Net Income + Interest + Taxes | $1,591.00 | $1,703.00 | |||||||||
| Interest | $118.00 | $157.00 | Net Fixed Assets | $3,156.00 | $3,437.00 | ||||||
| Income Tax | $309.00 | $325.00 | Total Assets | $5,918.00 | $6,755.00 | ||||||
| Net Income | $1,164.00 | $1,221.00 | Liabilities | ||||||||
| Dividends Paid | $700.00 | $711.00 | A/P | $635.00 | $820.00 | ||||||
| Notes Payable | $60.00 | $72.00 | |||||||||
| Other Current Liabilities | $25.00 | $50.00 | |||||||||
| ROA X b | 7.84% | 7.55% | ST Debt | $190.00 | $235.00 | ||||||
| ROE X b | $910.00 | $1,177.00 | |||||||||
| LTD | $2,690.00 | $2,750.00 | $60.00 | 2022 - 2021 | |||||||
| Equity | |||||||||||
| Common Stock | $715.00 | $715.00 | |||||||||
| OCF | $1,498.00 | Addt't Paid in Capital | $1,190.00 | $1,190.00 | $1,430.00 | Common Stock + Addt't Paid in Capital | |||||
| NCS | $401.00 | 2021 | 2022 | Retained Earnings | $413.00 | $923.00 | |||||
| NWC | $289.00 | $1,852.00 | $2,141.00 | Liabilities and Equity | $5,918.00 | $6,755.00 | |||||
| CFFA | $808.00 | ||||||||||
| CFS | $711.00 | ||||||||||
| CFC | $97.00 | ||||||||||
| Variance CFFA - (CFS+CFC) | $- |
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started
The Oxford Handbook Of Credit Derivatives
Authors: Alexander Lipton, Andrew Rennie
1st Edition
0199546789, 978-0199546787
