Spreadsheets are personal application software that includes a wide range of built-in functions for statistical, financial, logical, database, graphics, and date and time calculations. It is an application or program that is designed for analysis, organization and storing of data in a table form. It functions on data that are entered in the cells of a table where the cells can contain numeric or text values. In this program, you can input equations and relate cells in order to do automatic calculation. It helps in processing a large number of data since you can easily copy and execute functions and equations.
Answer:
the income that recognized on this investment is $10,500
Explanation:
The computation of the income recognized on this investment for the year 2021 is shown below"
= dividend × share of ownership
while
The dividend is $70,000
And, the share of ownership is 15%
Now place these values to the above formula
= $70,000 × 15%
= $10,500
hence, the income that recognized on this investment is $10,500
Answer:
Option (B) is correct.
Explanation:
100% complete for conversion cost the units that are complete.
Units that produced during the period:
= Units sold + Units of finished Ending - Beginning units of Finished
= 300,000 + 60,000 - 75,000
= 285,000 units
And work in process at ending is 24,000 units but for conversion costs is 75% only.
For conversion Equivalent units:
= 75% of Ending Work in process + Units that produced during the period
= 75% × 24,000 + 285,000
= 18,000+285,000
= 303,000 units
Answer:
Vo = <u>C1 </u> + <u>C2 + V2</u>
1 + k (1 + K)2
Vo = <u>$129,600 </u> + <u>$129,600 + $3,200,000</u>
1 + 0.14 (1 + 0.14)2
Vo = $113,684.21 + $2,562,019.08
Vo = $2,675,703.29
The correct answer is C
Explanation:
The current value of the business equals cashflow in year 1 divided by 1 + K plus the aggregate of cashflow and sales value in year 2 divided by 1 + k raised to power 2.
Answer:
C) ABC 5% and DEF 5.7%
Explanation:
Data provided in the question:
Purchasing Cost of Stock ABC purchased = $40 per share
Purchasing Cost of Stock DEF purchased = $35 per share
Time = 6 months
Selling price of share of ABC = $42 per share
Selling price of DEF share = $36
Dividend paid to the DEF = $0.5 each quarter i.e $0.5 twice in 6 months
Thus,
Total dividend paid to DEF = $0.5 × 2
= $1
Now,
For ABC
Total return = Selling price - Purchasing Cost
= $42 - $40
= $2 per share
thus,
Holding period return = [ Total return ÷ Purchasing cost ] × 100%
= [ $2 ÷ $40 ] × 100%
= 5%
For DEF
Total return = Selling price + Dividend received - Purchasing Cost
= $36 + $1 - $35
= $2 per share
thus,
Holding period return = [ Total return ÷ Purchasing cost ] × 100%
= [ $2 ÷ $35 ] × 100%
= 5.7%
Hence,
option C) ABC 5% and DEF 5.7%.
