1 / 26

BUSINESS MATHEMATICS & STATISTICS

BUSINESS MATHEMATICS & STATISTICS. LECTURE 18 Review Lecture 17 Solve two linear equations with two unknowns. DB EXAMPLES. =DB(A2,A3,A4,1,7) Depreciation in first year, with only 7 months calculated (186,083.33) =DB(A2,A3,A4,2,7) Depreciation in second year (259,639.42)

todd-hinton
Download Presentation

BUSINESS MATHEMATICS & STATISTICS

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. BUSINESS MATHEMATICS & STATISTICS

  2. LECTURE 18 Review Lecture 17 Solve two linear equations with two unknowns

  3. DB EXAMPLES • =DB(A2,A3,A4,1,7) Depreciation in first year, with only 7 months calculated (186,083.33) • =DB(A2,A3,A4,2,7) Depreciation in second year (259,639.42) • =DB(A2,A3,A4,3,7) Depreciation in third year (176,814.44) • =DB(A2,A3,A4,4,7) Depreciation in fourth year (120,410.64) • =DB(A2,A3,A4,5,7) Depreciation in fifth year (81,999.64) • =DB(A2,A3,A4,6,7) Depreciation in sixth year (55,841.76) • =DB(A2,A3,A4,7,5) Depreciation in seventh year, with only 5 months calculated (15,845.10)

  4. EXCEL FUNCTIONS FINANCIAL ANALYSIS PV  Returns the present value of an investment NPV    Returns the net present value of an investment based on a series of periodic cash flows and a discount rate

  5. PV(rate,nper,pmt,fv,type) Rate    interest rate per period Nper   total number of payment periods in an annuity Pmt  payment made each period and cannot change over the life of the annuity Fv   future value, or a cash balance you want to attain after the last payment is made Type   number 0 or 1 and indicates when payments are due.

  6. NPV NPV(rate,value1,value2, ...) Rate rate of discount over the length of one period Value1, value2, ...  1 to 29 arguments representing the payments and income

  7. EXCEL FUNCTIONS FINANCIAL ANALYSIS XNPV  Returns the net present value for a schedule of cash flows that is not necessarily periodic

  8. XNPV XNPV(rate,values,dates) Rate   discount rate to apply to the cash flows Values   series of cash flows that corresponds to a schedule of payments in dates Dates   schedule of payment dates that corresponds to the cash flow payments

  9. EXCEL FUNCTIONS FINANCIAL ANALYSIS SLN  Returns the straight-line depreciation of an asset for one period SYD Returns the sum-of-years' digits depreciation of an asset for a specified period

  10. EXCEL FUNCTIONS FINANCIAL ANALYSIS VDB Returns the depreciation of an asset for a specified or partial period using a declining balance method XIRR Returns the internal rate of return for a schedule of cash flows that is not necessarily periodic

  11. LINEAR EQUATIONS Solve two linear equations with two variables Solve problems that require setting up linear equations with two variables Perform linear Cost-Volume-Profit and break-even analysis employing: The contribution margin approach The algebraic approach of solving the cost and revenue functions

  12. SOLVING LINEAR EQUATIONS 2x – 3y = – 6 x + y = 2 Solve for y 2x – 3y =– 6 2x + 2y = 4 -5y = -10 Y = 2

  13. SOLVING LINEAR EQUATIONS 2x – 3y = – 6 x + y = 2 Solve for x Substitute y = 2 2x – 3(2) =– 6 2x - 6 = - 6 2x = 0 x = 0

  14. SOLVING LINEAR EQUATIONS 2x – 3y = – 6 x + y = 2 Solve for x Substitute y = 2 2x – 3(2) =– 6 2x - 6 = - 6 2x = 0 x = 0

  15. BUSINESS MATHEMATICS & STATISTICS

More Related