50.1K

Verified Solution

Link Copied!

Teamneme Andrews 1 SimID: F100803 017 1 Round: 2 1 Year 2021 Finance Recalculate Draft aved at Aug 01, 2019 01:48PM CDT Liabilities & Owner's Equity Finances C Accounts Payable: 7.2 % Plant Improvements Total Investments ($000) Retained Earnings: 13.9 %> Common Stock: 4.3 %- Sales of Plant &Equipment () Leng Term Debt: 8.1% Common Stock Shares Outstanding (000) ( 2,000 Price Per Share (D $12.53 Eamings Per Share D ($ 2.66) Current Debt: 66.5 % $5,012 Max Stock Issue ($000) (D Long Term Debt Retire Long Term Debt ($000) Issue Stock (5000) O Max Stock Retire ($000) (D $1,253 Issue Long Term Debt ($000) O Long Term Interest Rate Retire Stock ($000) D 10.4 % Oividend Per Share (D 0.00 Current Debt Maximum Issue This Year $3,928 9.0 % Interest Rate (O A/R Lag (days) 35 Due This Year ( $2,614 A/P Lag (days) O 35 Borow ($000) D Outstanding Bonds Cash Positions Current Yield 2020 Close ( Series Number Face Amount December 31, 2020 D $ 2,357 13.052025 11.8% $ 109.76 ($35,267) December 31, 2021 $ 97.58 10.052030 $2,000 10.3% Assets Liabilities & Owner's Equity Current Assets Cash (n Liabilities 0.0 % Accts Payable Current Borrowing O $0 $3,890 7.2% Accts Receivable ( $1,178 2.2% $0 0.0% Inventories ( $ 43,338 80.6% Emergency Loan D 66.5 % $35,767 Total Current Assets $ 44,517 82.8% Maturing L.T. Debt (D 0.0 % $0 Fixed Assets Long Term Debt ( $4,357 8.1% Plant & Equipment D Accum. Deprec. D $ 16.236 30.2% Total Liabilities $ 44,014 81.8% ($ 6,962) (12.9% ) Common Stock (D Retained Eam. D $2,323 4.3 % Total Fixed Assets $ 9,274 17.2% $7,453 13.9% TOTAL ASSETS $ 53,790 100.0% Total Equity TOTAL LIAB. & O.E $9.776 18.2% $53,790 100.0 % Assets Liabilities & Owner's Equity Cash: 0% Accounts Payable: 7.2 % Fixed 17.2 %- Retained Earnings 13.9 % Accounts Receivable : 2.2 % Common Stock 4.1% Long Term Debt 8.1%- Inventories 80.6% Current Debt 66.5% Sales D 100.0% $ 12,289 $0 $0 $0 $0 $12,289 VARIABLE COSTS Direct Labor D $3,937 $0 $0 $0 $0 $3,937 32.0% Direct Material (n $ 0 $4,544 $0 $0 $0 $4,544 37.0% Inventory Carry $5,201 $ 5,201 $0 $0 $0 $ 0 42.3% Total Variable Costs $13.682 $0 $0 $0 $0 $13,682 111.3% Contribution Margin (D (S 1,393) $0 (11.3) $0 $0 $0 ($1,393) PERIOD COSTS Depreciation ( SG&A: R&D O $1,080 $2 $0 $0 $0 $1,082 8.8% $ 0 $ 3,000 $1,000 S0 $0 $0 $1,000 8.1% Promotion O Sales O $0 $0 $ 0 $0 $0 $3,000 24.4% $1.000 $ 0 $ 0 $0 $ 1,000 8.1% Admin D $215 $0 $ 0 $ 0 1.8 % $215 Total Period Costs Net Margin $5,295 $1,002 $ 0 $0 $0 $6,297 51.2% (S 6,688) ($ 1,002) $ 0 $0 $0 ($7,691) (62.6 % ) 0.0 % Other (Fees, Write Offs, TQM) O EBIT D Interest (n $0 ($7,691) (62.6%) $506 4.1% Taxes (D ($ 2,869) (23.3 % ) Profit Sharing $0 0.0% Net Profit ( ($ 5,328) (43.4 % ) $20000 S1897703 $10000 $1,002.40 Able Aber Labor Material Inventory Carrying Costs Depreciation I Research & Development Marketing Administrative/Other Net Margin Teamname Andrews1 SimtD: F109803 017 I Round: 2 b Year: 2021 Finance Recalculate Draft saved at Aug 01, 2019 0148PM CDT Finances Liabilities & Owner's Equity Plant Improvements Accounts Payable: 7.2 N Retained Earnings: 13.9 % Total Investments ($000) O Common Stock:4.3 %- Sales of Plant & Equipment () Common Stock Long Term Debt: 8.1%- Shares Outstanding (000) (D Price Per Share O 2,000 $12.53 Eamings Per Share ( ($ 2.66) Current Debt: 66.5 % Max Stock Issue ($000) ( $5,012 Issue Stock ($000) ( Long Term Debt Max Stock Retire (5000) D Retire Long Term Debt ($000) (O Issue Long Term Debt ($000) (O $1,253 $ Retire Stock ($000) ( Dividend Per Share D Long Term Interest Rate 0.00 10.4% Current Debt Maximum Issue This Year D $3,928 Interest Rabe O 9.0% A/R Lag (days) 35 Due This Year $2,614 A/P Lag (days)( 35 Borrow ($000) (O 0 Outstanding Bonds Series Number Face Amount Cash Positions Current Yield December 31, 2020 2020 Close O $0 December 31, 2021 13.052025 ($ 35,267) $2,357 11.8% $109.76 10.052030 $ 2,000 $ 97.58 10.3% Ratios (13.4)% Return On Sales (ROS) or "Profitability" Profit/Sales Asset Tumover or "Tumover"-Sales/Assets (O 0.2 Retun On Assets (ROA) Profitablity Turnover n (9.9)% Leverage-Assets/Equity 5.5 Retum on Equty (RDE) Profit/Equty ( (54.5)% Free Cash Flow- Cash Flow From Ops-Capital Expenditures O ($33,153) Working Capital Current Assets-Current Labilibes (O $4,860 Days of Working Capital Working Capital/(Sales/365) D 144 Projected Stock Price $1.00 Market Captialization (SM)-Stock Price Shares Outstanding $2 Book Value Per Share Equity/Shares Outstanding O $ 4.89 Price Eamings Ratio (P/E)- Stock Price /EPS (0.4) Market/Book Ratio Stock Price/ Book Value per Share ( 0.2 Dividend YieldDividend Per Share/Stock Price O 0.0% Dividend PayoutRatio Dividend Per Share/EPS (O 0.0% ROS Asset Turnover Leverage ROE 0.3 7.5 ON 02 -25% -25% 01 2.5 5ON -50% -75% ROS Asset Turnover Leverage ROE II X Teamname: Andrews SimiD Pi00663 619 Round: 2 Year: 2021 Research & Development Recalculate Draft saved at Aug 01, 2019 01:37PM CDT Perceptual Map (at end of this year) Revision Date R&D Cost Age at Revision Name Pfmn Size MTBF 20 Able 7.2 13.0 13500 18 Aber 10.7 7.5 22000 09-Jun-22 0.0 16 NA 0.0 0.0 0 14 Able 12 NA 0.0 0.0 0 10 NA 0.0 0.0 0 Atjer Total $1444 02468 10 12 14 16 18 20 Performance Material Cost Age Profile 13.8 Able 13.8 Aber $2 50 $4 $6 $10 $12 $14 $16 Material Cost in dollars New Material Cost Old Material Cost Able Aber ES sueaA u aby paAjauad Teamname Andrews I SmlD: F100803 017 1 Round: 2 Years 2021 M Marketing Recalculate Draft saved at Aug 01, 2019 01:45PM CDT Less Promo Variable Costs Contrib Sales Benchmark Your Forecast Gross Revenue Price Name Budget Margin Promo/Sales Budget Prediction (S 151) Able $3,849 37.50 3000 $ 12,289 $8,439 1000 328 Aber $ 0 $ 0 10.00 $0 $0 0 0 $ 0 NA $0.0 $ 0 $ 0 C S0 NA $ 0 $0.0 S 0 $ 0 S0 C $0 $ 0 NA $ 0 $ 0 $0.0 C $0 Total $3,000 $1,000 328 $12,289 $8,439 $3,849 ($ 151) 0 A/R Lag (days) D: A/P Lag (days) GO: Revenue Forecast Unit Sales Forecast 15 0.4 $12,439 328 s 0.3 1C 02 0.1 Able Aber Able Aber Variable Cost Marketing Margin After Marketing Low High hone: 8T7L4T4 es,000 aseauo sages wun (s,000 up aseaauo anuana Teamneme: Andrews 1 SmD: F100803 017 1 Round 2 1 Year: 2021 Production & HR HR Recalculate Draft saved at Aug 01, 2019 0146PM CDT Schedule Staffing Last Year This Year Able Aber NA Total NA NA 308 Unit Sales Forecast () Needed Complement (O 308 328 328 Complement % O Complement O 100% Inventory On Hand (D 100% 427 427 308 Production Schedule (D 308 1600 1,600 1st Shift Complement D Production After Adj. (D 154 173 1,575 1,575 2nd Shift Complement D 154 135 Margins 0.0 % Overtime% O -0.2% Able Aber NA. NA NA Tumover Rate New Employees O 10.0% 10.0% 2nd Shift Production% () Labor Cost/Unit (D 0.0 % 0.0 % 0.0 % 77.8% 0.0% 31 91 $0.00 $11.96 $0.00 $0.00 $0.00 Separated Employees ( 0 Material Cost/Unit () $0.00 $0.00 $13.80 $23.84 $0.00 Recruiting Spend $ 0 $C Total Unit Cost (O $23.84 $0.00 0.00 $0.00 $25.75 Training Hours Contribution Margin D 0.0 % 0.0 % 00% 31.3% ($ 138)% 100.0 % Productivity Index O 100.0% Physical Plant Recr Cost O $31 NA Total Able Aber NA NA Separation Cost n so 1st Shift Capacity (D 902 900 Training Cost ( Buy/Sell Capacity O 0 0 Total HR Admin Costs $31 Automation Rating (D) 3.0 3.0 3.0 New Autom. Rating ) 3.0 $0 S0 Investment ($000) ( $0 $0 $0 $0 $,940 Max Invest O 35 A/P Lag (days) (D Teamneme Andrews 1 SimID: F100803 017 1 Round: 2 1 Year 2021 Finance Recalculate Draft aved at Aug 01, 2019 01:48PM CDT Liabilities & Owner's Equity Finances C Accounts Payable: 7.2 % Plant Improvements Total Investments ($000) Retained Earnings: 13.9 %> Common Stock: 4.3 %- Sales of Plant &Equipment () Leng Term Debt: 8.1% Common Stock Shares Outstanding (000) ( 2,000 Price Per Share (D $12.53 Eamings Per Share D ($ 2.66) Current Debt: 66.5 % $5,012 Max Stock Issue ($000) (D Long Term Debt Retire Long Term Debt ($000) Issue Stock (5000) O Max Stock Retire ($000) (D $1,253 Issue Long Term Debt ($000) O Long Term Interest Rate Retire Stock ($000) D 10.4 % Oividend Per Share (D 0.00 Current Debt Maximum Issue This Year $3,928 9.0 % Interest Rate (O A/R Lag (days) 35 Due This Year ( $2,614 A/P Lag (days) O 35 Borow ($000) D Outstanding Bonds Cash Positions Current Yield 2020 Close ( Series Number Face Amount December 31, 2020 D $ 2,357 13.052025 11.8% $ 109.76 ($35,267) December 31, 2021 $ 97.58 10.052030 $2,000 10.3% Assets Liabilities & Owner's Equity Current Assets Cash (n Liabilities 0.0 % Accts Payable Current Borrowing O $0 $3,890 7.2% Accts Receivable ( $1,178 2.2% $0 0.0% Inventories ( $ 43,338 80.6% Emergency Loan D 66.5 % $35,767 Total Current Assets $ 44,517 82.8% Maturing L.T. Debt (D 0.0 % $0 Fixed Assets Long Term Debt ( $4,357 8.1% Plant & Equipment D Accum. Deprec. D $ 16.236 30.2% Total Liabilities $ 44,014 81.8% ($ 6,962) (12.9% ) Common Stock (D Retained Eam. D $2,323 4.3 % Total Fixed Assets $ 9,274 17.2% $7,453 13.9% TOTAL ASSETS $ 53,790 100.0% Total Equity TOTAL LIAB. & O.E $9.776 18.2% $53,790 100.0 % Assets Liabilities & Owner's Equity Cash: 0% Accounts Payable: 7.2 % Fixed 17.2 %- Retained Earnings 13.9 % Accounts Receivable : 2.2 % Common Stock 4.1% Long Term Debt 8.1%- Inventories 80.6% Current Debt 66.5% Sales D 100.0% $ 12,289 $0 $0 $0 $0 $12,289 VARIABLE COSTS Direct Labor D $3,937 $0 $0 $0 $0 $3,937 32.0% Direct Material (n $ 0 $4,544 $0 $0 $0 $4,544 37.0% Inventory Carry $5,201 $ 5,201 $0 $0 $0 $ 0 42.3% Total Variable Costs $13.682 $0 $0 $0 $0 $13,682 111.3% Contribution Margin (D (S 1,393) $0 (11.3) $0 $0 $0 ($1,393) PERIOD COSTS Depreciation ( SG&A: R&D O $1,080 $2 $0 $0 $0 $1,082 8.8% $ 0 $ 3,000 $1,000 S0 $0 $0 $1,000 8.1% Promotion O Sales O $0 $0 $ 0 $0 $0 $3,000 24.4% $1.000 $ 0 $ 0 $0 $ 1,000 8.1% Admin D $215 $0 $ 0 $ 0 1.8 % $215 Total Period Costs Net Margin $5,295 $1,002 $ 0 $0 $0 $6,297 51.2% (S 6,688) ($ 1,002) $ 0 $0 $0 ($7,691) (62.6 % ) 0.0 % Other (Fees, Write Offs, TQM) O EBIT D Interest (n $0 ($7,691) (62.6%) $506 4.1% Taxes (D ($ 2,869) (23.3 % ) Profit Sharing $0 0.0% Net Profit ( ($ 5,328) (43.4 % ) $20000 S1897703 $10000 $1,002.40 Able Aber Labor Material Inventory Carrying Costs Depreciation I Research & Development Marketing Administrative/Other Net Margin Teamname Andrews1 SimtD: F109803 017 I Round: 2 b Year: 2021 Finance Recalculate Draft saved at Aug 01, 2019 0148PM CDT Finances Liabilities & Owner's Equity Plant Improvements Accounts Payable: 7.2 N Retained Earnings: 13.9 % Total Investments ($000) O Common Stock:4.3 %- Sales of Plant & Equipment () Common Stock Long Term Debt: 8.1%- Shares Outstanding (000) (D Price Per Share O 2,000 $12.53 Eamings Per Share ( ($ 2.66) Current Debt: 66.5 % Max Stock Issue ($000) ( $5,012 Issue Stock ($000) ( Long Term Debt Max Stock Retire (5000) D Retire Long Term Debt ($000) (O Issue Long Term Debt ($000) (O $1,253 $ Retire Stock ($000) ( Dividend Per Share D Long Term Interest Rate 0.00 10.4% Current Debt Maximum Issue This Year D $3,928 Interest Rabe O 9.0% A/R Lag (days) 35 Due This Year $2,614 A/P Lag (days)( 35 Borrow ($000) (O 0 Outstanding Bonds Series Number Face Amount Cash Positions Current Yield December 31, 2020 2020 Close O $0 December 31, 2021 13.052025 ($ 35,267) $2,357 11.8% $109.76 10.052030 $ 2,000 $ 97.58 10.3% Ratios (13.4)% Return On Sales (ROS) or "Profitability" Profit/Sales Asset Tumover or "Tumover"-Sales/Assets (O 0.2 Retun On Assets (ROA) Profitablity Turnover n (9.9)% Leverage-Assets/Equity 5.5 Retum on Equty (RDE) Profit/Equty ( (54.5)% Free Cash Flow- Cash Flow From Ops-Capital Expenditures O ($33,153) Working Capital Current Assets-Current Labilibes (O $4,860 Days of Working Capital Working Capital/(Sales/365) D 144 Projected Stock Price $1.00 Market Captialization (SM)-Stock Price Shares Outstanding $2 Book Value Per Share Equity/Shares Outstanding O $ 4.89 Price Eamings Ratio (P/E)- Stock Price /EPS (0.4) Market/Book Ratio Stock Price/ Book Value per Share ( 0.2 Dividend YieldDividend Per Share/Stock Price O 0.0% Dividend PayoutRatio Dividend Per Share/EPS (O 0.0% ROS Asset Turnover Leverage ROE 0.3 7.5 ON 02 -25% -25% 01 2.5 5ON -50% -75% ROS Asset Turnover Leverage ROE II X Teamname: Andrews SimiD Pi00663 619 Round: 2 Year: 2021 Research & Development Recalculate Draft saved at Aug 01, 2019 01:37PM CDT Perceptual Map (at end of this year) Revision Date R&D Cost Age at Revision Name Pfmn Size MTBF 20 Able 7.2 13.0 13500 18 Aber 10.7 7.5 22000 09-Jun-22 0.0 16 NA 0.0 0.0 0 14 Able 12 NA 0.0 0.0 0 10 NA 0.0 0.0 0 Atjer Total $1444 02468 10 12 14 16 18 20 Performance Material Cost Age Profile 13.8 Able 13.8 Aber $2 50 $4 $6 $10 $12 $14 $16 Material Cost in dollars New Material Cost Old Material Cost Able Aber ES sueaA u aby paAjauad Teamname Andrews I SmlD: F100803 017 1 Round: 2 Years 2021 M Marketing Recalculate Draft saved at Aug 01, 2019 01:45PM CDT Less Promo Variable Costs Contrib Sales Benchmark Your Forecast Gross Revenue Price Name Budget Margin Promo/Sales Budget Prediction (S 151) Able $3,849 37.50 3000 $ 12,289 $8,439 1000 328 Aber $ 0 $ 0 10.00 $0 $0 0 0 $ 0 NA $0.0 $ 0 $ 0 C S0 NA $ 0 $0.0 S 0 $ 0 S0 C $0 $ 0 NA $ 0 $ 0 $0.0 C $0 Total $3,000 $1,000 328 $12,289 $8,439 $3,849 ($ 151) 0 A/R Lag (days) D: A/P Lag (days) GO: Revenue Forecast Unit Sales Forecast 15 0.4 $12,439 328 s 0.3 1C 02 0.1 Able Aber Able Aber Variable Cost Marketing Margin After Marketing Low High hone: 8T7L4T4 es,000 aseauo sages wun (s,000 up aseaauo anuana Teamneme: Andrews 1 SmD: F100803 017 1 Round 2 1 Year: 2021 Production & HR HR Recalculate Draft saved at Aug 01, 2019 0146PM CDT Schedule Staffing Last Year This Year Able Aber NA Total NA NA 308 Unit Sales Forecast () Needed Complement (O 308 328 328 Complement % O Complement O 100% Inventory On Hand (D 100% 427 427 308 Production Schedule (D 308 1600 1,600 1st Shift Complement D Production After Adj. (D 154 173 1,575 1,575 2nd Shift Complement D 154 135 Margins 0.0 % Overtime% O -0.2% Able Aber NA. NA NA Tumover Rate New Employees O 10.0% 10.0% 2nd Shift Production% () Labor Cost/Unit (D 0.0 % 0.0 % 0.0 % 77.8% 0.0% 31 91 $0.00 $11.96 $0.00 $0.00 $0.00 Separated Employees ( 0 Material Cost/Unit () $0.00 $0.00 $13.80 $23.84 $0.00 Recruiting Spend $ 0 $C Total Unit Cost (O $23.84 $0.00 0.00 $0.00 $25.75 Training Hours Contribution Margin D 0.0 % 0.0 % 00% 31.3% ($ 138)% 100.0 % Productivity Index O 100.0% Physical Plant Recr Cost O $31 NA Total Able Aber NA NA Separation Cost n so 1st Shift Capacity (D 902 900 Training Cost ( Buy/Sell Capacity O 0 0 Total HR Admin Costs $31 Automation Rating (D) 3.0 3.0 3.0 New Autom. Rating ) 3.0 $0 S0 Investment ($000) ( $0 $0 $0 $0 $,940 Max Invest O 35 A/P Lag (days) (D

Answer & Explanation Solved by verified expert

See Answer