Answer:
18.54%
Explanation:
The computation of the project modified IRR is shown below:
Here we use the spreadsheet for determining the IRR
but before that we need to find out the cash inflows
Years Amount (in dollars)
Year 0: = - $278,191.12
($236,000 - $48,000 ÷ 1.13^4 -$30,000 ÷ 1.13^7)
Year 1: 64000
Year 2: 87000
Year 3: 91000
Year 4: 0
Year 5: 122000
Year 6: 154000
Year 7: 0
Now we use the excel
=IRR({-$278,191.12,$64,000,$87,000,$91,000,$0,$122,000,$154,000,0})
= 18.54%
Answer:
depending on the place you can consider the number of people who go to it and on that side, the fame it would have for its service, and greater economic progress.
Explanation:
Answer:
monthly insurance payments = $29.94
Explanation:
given data
hazard coverage = $98,000
annual premium = $0.44 per $100.00
cost of the policy = 2 ½ times annual rate for 3 year policy
solution
we get here first normal premium cost per year that is
normal premium cost per year = $98000 × 0.44 ×
normal premium cost per year = $431.2
and
insurance company is offering for new owner discount for purchasing a three year policy
so here the total cost for the three year is
total cost for the three = $431.2 × 2.5 = $1078
and now we get monthly insurance payments for 3 year is
monthly insurance payments =
monthly insurance payments = $29.94
Answer:
Reliability over relevance
Explanation:
The historical cost principle states that assets must be recorded at purchase cost, disregarding any change in their market value. E.g. you purchased a land lot 10 years ago for $100,000 and now it is worth $500,000. It must be recorded at $100,000 since that was its original purchase cost.
Accounting tries to be as exact as possible, and if the carrying values started to change every period or even month by month because the accountant believed that the market value changed, then it would be a mess. Accountancy is not supposed to be a game of guessing, it is supposed to be as exact and reliable as possible.
Answer:
D. Column#Row#+Column#Row#
Explanation:
A spreadsheet can be defined as a file or document which comprises of cells in a tabulated format (rows and columns) typically used for formatting, arranging, analyzing, storing, calculating and sorting data on computer systems through the use of Microsoft Excel.
Microsoft Excel is a software application or program designed and developed by Microsoft Inc., for analyzing and visualizing spreadsheet documents.
In Microsoft Excel, the SUMIF function is a function that is designed to used to sum cells that meet criteria such as text, dates, and numbers. Also, this function can be used with the following logical operators; <, >, and =.
On a related note, the formula that would be used to add two cells together after the equal sign is Column#Row#+Column#Row#.
For example, A10B2 + A14B3.