FINA 6200 Final Exam Excel Work Conner Brailsford

.xlsx
School
Northeastern University **We aren't endorsed by this school
Course
FINA 6200
Subject
Finance
Date
Oct 15, 2023
Pages
6
Uploaded by GrandClover8421 on coursehero.com
4) I 8% N 6 PMT 0 PV -1000 FV $1,586.87 5) I 6% N 5 PMT -1000 PV 0 FV $5,637.09 6) I 7% N 8 PMT 0 PV ($582.01) FV 1000 7) I 14% N 4 PMT 70 PV ($796.04) FV 1000 10) 33.3333333333333 12) 0.0865625 14% -32 5.25 5.25 5.25 5.25 $34.77 $2.77 15% 15) I 0.0148 N 50 PMT 17.25 PV ($1,086.13) FV 1000 16) rs 15% g6 4.50% D0 $ - D1 $ - D2 $ - D3 $ -
D4 $ 1.50 D5 $ 1.85 D6 $ 2.25 P5 $ 21.43 P0 $10.81 17) NI $ 100.00 $ 100.00 CE $ 25.00 $ 18.75 ROE 4 5.3333333333 19) Purchase $ (750,000.00) Shipping $ (50,000.00) Total $ (800,000.00) Year 1 Year 2 Sales $ 380,000.00 $ 380,000.00 Expenses $ 60,000.00 $ 60,000.00 Depreciation $ (247,500.00) $ (337,500.00) $ 192,500.00 $ 102,500.00 Taxes $ (48,125.00) $ (25,625.00) WACC 13% $ 144,375.00 $ 76,875.00 $ 247,500.00 $ 337,500.00 $ (800,000.00) $ 391,875.00 $ 414,375.00 NPV cash flows $1,129,952.02 NPV $329,952.02 IRR 32.27% 20) Trade Credit Discount % 2% Cash Discount Period 10 Credit Period 45 Days in a year 365 N 0.09589041096 PV $ 49,000.00 FV $ (50,000.00) PMT $ - I 23.45% EAR 23.45% Add on Principal $ 50,000.00 Interest rate 10% Interest $ 5,000.00 Total Owed $ 55,000.00 Monthly Payment $ 4,583.33
N 12 PV $ 50,000.00 PMT $ (4,583.33) FV $ - I 1.50% EAR 19.53%
Page1of 6
Uploaded by GrandClover8421 on coursehero.com