Answered step by step
Verified Expert Solution
Question
1 Approved Answer
i need help with this assignment, please show all work so i could follow. I'm having a lot of difficulty with the calculator im supposed
i need help with this assignment, please show all work so i could follow.
I'm having a lot of difficulty with the calculator im supposed to use for the first part, so any help will be appreciated
calculator im using is the sharp el 738f
Find payment N = 30 years, monthly payments Interest rate = 8%, compounded monthly PV = 1,200,000 FV = 0 Compute PMT Find Future Value N = 30 years, monthly payments Interest rate = 8%, compounded semiannually PV = 0 PMT = -900 Compute FV Find Present Value N = 30 year, monthly payments Interest rate = 8%, compounded monthly PMT = 0 FV = -1,000,000 Compute PV Find payment N = 30 years, semiannual payments Interest rate = 8%, compounded semiannually PV = 0 FV = -1,000,000 Compute PMT Find interest rate in Annuity Due Interest rate compounded monthly PV = 20,000 PMT = -350 FV = -5000 Compute annual interest rate 1 6 Find present value in Annuity Due N = 5 years, monthly payments Interest rate = 8%, compounded monthly PMT = -1000x(8%/12) FV = -1000 Compute PV 1 7 Find present value in Ordinary annuity N = 30 years, monthly payments Interest rate = 8%, compounded monthly PMT = -850 FV = 0 Compute PV Questions 18-27 use the same data 1 8 Mortgage - Find payment N = 20 years, monthly payments, starts at end of January Interest rate = 7%, compounded monthly PV = 350,000 FV = 0 Compute payment PMT P1 = 1 P2 = 12 1 9 2 0 2 1 Balance at end of December in first year Total Principal Repayment at end of first year Total Interest payments at end of first year P1 = 61 P2 = 72 2 2 2 3 2 4 Balance at end of December in 6th year 2 5 2 6 2 7 Balance at end of December in 11th year Total Principal Repayment in 6th year Total Interest payments in 6th year Total Principal Repayment in 11th year Total Interest payments in 11th year Questions 28 - 31 use the same data 2 8 Find Mortgage payment N = 30 years, monthly payment, Annuity Due Interest rate = 5.25%, compounded monthly PV = 200000 FV = 0 Compute PMT P1 = 1 P2 = 120 2 9 3 0 Balance after 10 years of payments Total Principal Repayment after 10 years of payments 3 1 Total interest payments after 10 years of payments 32 Compute IRR using following data: CF0=-10000 CF1=2500 CF2=2500 CF3=3500 CF4=3500 CF5=5000 33 Compute NPV Same cash flows as Q32 Interest rate = 8% Part II: Financial Statements Review (35 marks) 1. Build the Income Statement and Balance Sheet for CanDo Inc. based on the information given below, as of December 31, 2009. Accounts payable Accounts receivable Cash and cash equivalents CoGS Common Stock Depreciation Dividend payout ratio Interest paid Inventory Long-term debt Net Fixed Assets Sales Short-term debt Tax rate Number of shares Price per share $141,000 $103,000 $154,000 $224,700 $1,286,00 0 $37,000 40% $43,000 $129,000 $1,254,00 0 $2,530,00 0 $330,000 $132,000 35% 1,000,000 $0.50 2. Obtain the following numbers from the income statement and balance sheet: (i) Total Current Assets (ii) Total Current Liabilities (iii) Retained Earnings (iv) Total Owners' Equity (v) Total Assets (vi) Earnings before depreciation, interest and taxes (EBDIT) (vii) Earnings before interest and taxes (EBIT) (viii) Dividends (ix) Addition to Retained Earnings Part III: Financial Ratios Review (32 marks) The following table presents the data for CanDo Inc. in as of December 31 2008: Accounts payable Accounts receivable Cash and cash equivalents CoGS Common Stock Depreciation Dividend payout ratio Interest paid Inventory Long-term debt Net Fixed Assets Sales Short-term debt Tax rate $104,000 $146,000 $108,000 $224,700 $1,286,00 0 $37,000 40% $43,000 $123,000 $1,254,00 0 $2,467,00 0 $330,000 $106,867 35% Calculate the following financial ratios for CanDo Inc. in the fiscal year of 2009: a. Current ratio b. Quick ratio c. Cash ratio d. Net working capital ratio e. Interval measure f. Total debt ratio g. Debt-equity ratio h. Equity multiplier i. Long-term debt ratio j. Times interest earned k. Cash coverage ratio l. Inventory turnover (using average inventory from 2008 and 2009) m. Days' sales in inventory n. Receivables turnover (using average accounts receivable from 2008 and 2009) o. Days' sales in receivables p. Payables turnover (using average accounts payable from 2008 and 2009) q. Days' sales in payables r. NWC turnover s. Fixed assets turnover t. Total asset turnover u. Profit margin v. Return on assets (ROA) w. Return on equity (ROE) x. Price-earnings (P/E) ratio y. Market-to-book ratioStep 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